Error with IF and Vlookup

Occasional Visitor

Hi everyone,


I am having issues trying to use IF's and Vlookups.


My Problem/Issue:


I need a formula then looks to see if a Name is in Sheet1 but Not in Sheet2. If it this is True then the value is 'No Match' and if false the Value to be 'Match'.


But I can't figure out the logic needed for my formula.



1 Reply


Something like


=IF(COUNTIF(Sheet2!$A$1:$Z$100, A1)=0, "No Match", "Match")


where Sheet2!$A$1:$Z$100 is the range you want to search, and A1 is the name to search for.