Need Help testing if a cells contents match that of a cell in another column

Hello,

I am trying to test a column of cells to see if an individual cell's contents match the cell contents of any cell in another column.

What I have is two list of data, in alpha-numeric format. I want to see what data exist in both lists.

Thanks in advance,

Originally Posted by NBVC

Try:

=Isnumber(match(A1,B1:B100,0)) copied down


this looks in B1:B100 for a match to cell A1's contents... if a match is found TRUE is returned, else you get FALSE.

Adjust references to suit

Thanks!

Works great, except this newbie needs help with one thing, when I copy down, it adjusts the range on the "B1:B100", so the next one is searching in "B2:B201"

Is there a way to copy without it automatically changing the range?

Originally Posted by NBVC

Good point... we need to freeze that range....

Please Login or Register  to view this content.

Thanks Again!

I use excel all the time, and I always suffer these little details!