matching columns of numbers

  • Thread starter Thread starter toledo
  • Start date Start date
T

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 ***
 
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
 
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)
 
Back
Top