vlookup,IF function together

  • Thread starter Thread starter Ranjit kurian
  • Start date Start date
R

Ranjit kurian

Hi
i know to do vlookup, but the problem here is, when i do vlookup function
and if the value is found then the result should be shown as "YES" if not
then "NO"
 
You don't need VLOOKUP for that, you can just use MATCH

=IF(ISNUMBER(MATCH(lookup_value,A1:A100,0)),"YES","NO")

where A1:A100 with be the equivalent of the first column (leftmost) in a
VLOOKUP formula


--


Regards,


Peo Sjoblom
 
Something like this:

=IF(ISNA(your_vlookup_formula),"No","Yes")

You could use MATCH instead of VLOOKUP.

Hope this helps.

Pete
 
Something like this should do it for you
Assume your vlookup col (the 1st col) is col A in Sheet1
In Sheet2,
In B1:
=IF(A1="","",IF(ISNUMBER(MATCH(A1,Sheet1!A:A,0)),"Yes","No"))
Copy B1 down
 
One way:

=IF(ISNA(MATCH(<value>,<range>,FALSE)),"NO","YES")

Another:

=IF(COUNTIF(<range>,<value>)>0,"YES","NO")
 
Back
Top