Match Data in Multiple Columns

W

Walter

I would like to be able to search for data in 3 or 4 different columns and if
the items match then it lets me know what row that is. For example: Right
now I have this formula:
=IF(ISNUMBER(MATCH(E2,A:A,0)),"A"&MATCH(E2,A:A,0),"no") which finds what I
want in one column and then reports the row. Can I adjust this to include
the ability to search on columns A, B, and C?

ColA ColB ColC ColD
Row1 1/1/08 00012 12345 614
Row2 3/15/08 00034 6789 625

From another set of data, I want to seach in this set of data for 1/1/08 and
00012 and 12345 and if the data matches that set then return the row#.
Hopefully that makes sense.

Walter
 
M

Max

One simple way to extend it using your current expression

In both Sheet1 and Sheet2 (assumed to be the other data set, identically
structured as the source Sheet1), just use a helper col, say col G, to concat
the 3 col fields together, eg:

In G1 (in both Sheets 1 & 2), copied down:
=A1&"#"&B1&"#"&C1&"#"

Then you could deploy your current expression like this
in say, Sheet1's H1, copied down:
=IF(ISNUMBER(MATCH(G1,Sheet2!G:G,0)),"A"&MATCH(G1,Sheet2!G:G,0),"no")
 
M

Max

Typo in G1's formula, line should read as:

In G1 (in both Sheets 1 & 2), copied down:
=A1&"#"&B1&"#"&C1
 

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

Top