Microsoft Excel - If Formula Help - Asked By anu anu on 19-Dec-13 01:19 AM

Hi,

 i  have data with me in difftent sheet i need if my 3 condition are match with sheet 2 then in sheet one shows yes like ,

 in sheet two

Item	SR NO
ABC	78596
sdp	8526

 and in sheet one:

Item	SR NO	Yes
xyz	78596	NO
sdp	8526	Yes

i want if SR No And Item match then shows yes other wise NO

Regards
Anu

Hello Anu,
Try

=IF(AND(NOT(ISNA(VLOOKUP(A2,Sheet2!A:A,1,FALSE))),NOT(ISNA(VLOOKUP(B2,Sheet2!B:B,1,FALSE)))),"yes","no")

Please be aware that the values do not have to be on the same line on Sheet2 to get a positive result.  If they have to be on the same line that is another thing altogether.

For this case try

=IF(SUMPRODUCT((Sheet2!A:A=Sheet1!A2)*(Sheet2!B:B=Sheet1!B2)),"YES","NO")

Regards
Harry

thank you  Harry it`s working ....