Formula Help

sam2015

New member
Joined
Jul 9, 2015
Messages
1
Reaction score
0
Points
0
I have a document with two sheets and I need to find a formula that can check Column A and Column E in Sheet 1 against Column A and column B in Sheet 2. If its an EXACT MATCH I want it to return the result of the value in Column D in Sheet 2. Could somebody please help???
 
Hi sam2015,
Try below formula in cell D1(Sheet2).
=IF(AND(EXACT(A1,Sheet1!A1),EXACT(Sheet2!B1,Sheet1!E1)),"Match","Not Match")

Plz see the attachment.
 

Attachments

  • Example.xlsx
    8.3 KB · Views: 3
I tried, but couldn't fault this compared with the one using EXACT:

=IF(AND(Sheet1!A1= A1, Sheet1!E1=B1),D1,"")

This assumes that you are returning the result somewhere in sheet2, and it returns blank if there is a mismatch.
 
Back
Top