I have managed to create a formula, using if, isna & vlookup, that shows when there is a match between the data in Cell A2 & B2 on Sheet 2 and the range A2:B4000 on Sheet 1 “=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$4000,2,FALSE)=Sheet2!B2),"Found It","Keep Looking")” however….. I have instances where the data in Cell A2 on Sheet two can be repeated many times within the range of A2:A4000 on Sheet 1 but the detail in column B differs with each entry in column A.
Can anybody advise of a way to force the formula above to continue looking if… A2 on Sheet two matches A17 on Sheet 1 but does not match B17? Or an alternative solution please.
Many Thanks
Empty1
Can anybody advise of a way to force the formula above to continue looking if… A2 on Sheet two matches A17 on Sheet 1 but does not match B17? Or an alternative solution please.
Many Thanks
Empty1
Last edited: