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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ranjit kurian" wrote:
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"