Look into another workbook and if the value is there, mark as Yes

[papasmurfuo9]

Hi

i have two workbooks, lets say book1 and book2


in column A of book 1 i have a list of numbers, going down to A250

A1 = 23423423
A2 = 23442345

etc etc

I would like some code for a button press, if the value in A1:A250 is in book2 (A1:A250)
Both workbooks will be open at the point of the button press

then adjacent cell in B1:B250 is marked as Yes

hope this is clear, thanks in advance

[millz]

Hi, you should be able to do it with a simple VLOOKUP formula

in Cell B1 and copy down. Probably need to change [Book2]Sheet1!$A:$A to suit.

Please Login or Register  to view this content.

[papasmurfuo9]

Hi

i applied it to my cell references (used above to make it easier)
and it doesnt appear to work

Please Login or Register  to view this content.

the above is right?

thanks

[papasmurfuo9]

tried this way too, no matter what it returns as "FALSE":s

Please Login or Register  to view this content.

[guitarsweety]

try this

Please Login or Register  to view this content.

[millz]

See sample workbook to show that the same formula works, except it is looking at Sheet2 in the same workbook.

Reason why it didn't work for you should be because you messed up the formula somewhere.

What you can try is remove the part of there formula stating the range of cells to look up, and then manually switch over to your workbook and select the range -- let Excel fill in the range.


Edit: Didn't notice you have marked it solved.