matching columns of numbers

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 ***
 
F

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
 
D

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Merging from an Excel file with graphics 1
lookup and return column number 2
Changing column reference for number of formulas at once 1
help on a formula (match and etc..) 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
How to do an IF statement that copy data based on a partial match 0
Index/Match with text-looking numbers 1

Top