Hello,

I was wondering if there was a way to create a formula which captured
information from two separate cells in two separate columns but allowed you
to capture every time these two fields are in the same row. For example

Column A Column B
A 1
B 2
C 3
D 4

I would need a formula which would capture every time that "A" and "4" are
in the same row at any given time.

Hope you can help!

Thanx!

Srain