"-Column search

[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

 

[George]

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

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

 

[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.