Vlookup
Hi,
Not enought info, best to show us a sample of the data
Suppose the letters A, B, C are located in Sheet2 range A1:A10 then
=IF(ISNA(VLOOKUP(A1,Sheet2!A$1:A$10,1,FALSE)),""," Y")
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"H" wrote:
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
|