Excel 2007 : Display cell address if condition is matched

It seems like you are searching for coordinate "pairs". If so, then how about:

in cell E1 use:

=ADDRESS(MATCH(C1&D1,A1:A200&B1:B200,0),COLUMN(A1),1,1)

using Ctrl-Shift-Enter.

and in cell F1 use:

=ADDRESS(MATCH(C1&D1,A1:A200&B1:B200,0),COLUMN(B1),1,1)

using Ctrl-Shift-Enter.

If this isn't it either, then could you attach a sample spreadsheet with sample data, and an example of what you expect the result to show?

Cheers,