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