Vlookup
If you combined it with a IF function, yeah, you could do that. Shorter
function (and more clear what your doing) would be to use MATCH
=IF(ISNUMBER(MATCH(A1,'Sheet1'!A:A,0)),"Y","")
placed into B1 and copied down will let you know if the value in column A is
in column A of Sheet1.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"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
|