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

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Walter" wrote:
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

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

In G1 (in both Sheets 1 & 2), copied down:
=A1&"#"&B1&"#"&C1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---