In a helper column, enter:

=A1&B1 and copy down

Then apply AutoFilter and you will be able to locate every row in which the
helper is A4
--
Gary's Student
gsnu200704


"srain001" wrote:

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