matching columns of numbers

[toledo]

In EXCEL 2000 for Windows, I have two columns of numbers. Column A has
500 numbers, Column B has 1000 numbers. I need to know which cells in
Column A have a match in Column B, and if so, what is the Cell (or row
number) in B that matches to that particular cell in A. How can I do
this?
Thank you for your help.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Frank Kabel]

Hi
try the following:
- insert a new column between A and B (so make B the new C column)
enter the following in B1
=IF(ISNA(MATCH(A1,$C$1:$C$1000,0)),"No match","Match in row#: " &
MATCH(A1,$C$1:$C$1000))
and copy down

 

[Dave Peterson]

I think Frank dropped a 0 in his last expression:

=IF(ISNA(MATCH(A1,$C$1:$C$1000,0)),"No match",
"Match in row#: " & MATCH(A1,$C$1:$C$1000,0))

(still all one cell)

 

[Frank Kabel]

Good spot.
Thanks Dave