"-Column search

P

Paddy Duncan

I have 2 columns - Forename + Surname.
How do I search for a matching pair ie 'John Smith', when John and
Smith are in different columns? Thanks in advance + apologies is this
is already answered - I can't seem to find it.
Paddy
 
G

George

Paddy said:
I have 2 columns - Forename + Surname.
How do I search for a matching pair ie 'John Smith', when John and
Smith are in different columns? Thanks in advance + apologies is this
is already answered - I can't seem to find it.
Paddy
Click to expand...

You could create another column (C for example) containing the
combination of Forename and Surname using the formula "=A1 & " " & B1"
assuming column A contains the Forename and column B contains the
Surname, and then perform a search in column C.

George
 
D

Dave Peterson

Another option is to apply Data|filter|autofilter to your range (both columns).

then filter on the first column for John (or contains John????).

then filter on the second for the lastname.
 
Top