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

@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.