Error with IF and Vlookup

[TBoch]

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.

[#2]

@TBoch 

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.