Vlookup
One way:
=IF(COUNTIF(Sheet2!A:A,A1),"Y","")
Copy down as needed.
--
Biff
Microsoft Excel MVP
"H" wrote in message
...
Is it possible to do a lookup that allows you to look at another tab and
say
if it's in that list then tag it with a yes? and if its not leave it
blank?
for example:
Column A Column B
A Y
B
C Y
the corresponding tab will have some that match Column A -- if there is
one
corresponding can Column B show a Y
Thanks
|