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

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

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

thank you -- works perfectly :)

"Luke M" wrote:

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

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