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