Comparing Two Large Data Lists

J

justinfoote

I have two large lists in one spreadsheet, one in column A and one in
column C. I'd like to search through column A to find a certain value
from column C. I'm hoping to get something that will return a row
number for the entry in column A that matches the entry in column C.
So D1 will contain the row number in column A that matches C1
D2 will contain the row number in column A that matches C2, etc
 
M

Max

I have two large lists in one spreadsheet, one in column A and one in
column C. I'd like to search through column A to find a certain value
from column C. I'm hoping to get something that will return a row
number for the entry in column A that matches the entry in column C.
So D1 will contain the row number in column A that matches C1
D2 will contain the row number in column A that matches C2, etc
Click to expand...

Put in D1: =MATCH(C1,A:A,0)
Copy D1 down
 

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

Extracting a cell value 2
Macro for comparing columns and highlighting matching/differences 13
lookup and return column number 2
Changing column reference for number of formulas at once 1
Comparing numbers 1
How to pull in data from rows and columns if there are blanks? 0
Matching data in columns 1
Sheet to sheet code Type Mismatch 6

Top