Match Data in Multiple Columns

[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

 

[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")

 

[Max]

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

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