Find

R

Roger

I have a worksheet with 100’s of names. The first & last names are on
separate cells (in the same row).
I am trying to find “JOHN DOEâ€, how do I search for it?
 
M

Miguel Zapico

You can create a column with the two names joined, with a formula like:
=A1 & " " & B1
And then use the menu Edit -> Find. You need to assure that you look for
values, that setting can be found on the options section, in the "look in"
drop down.

Hope this helps,
Miguel.
 
R

Ron Coderre

Maybe something like this:

For a list of names in A1:B1000 (Col_A holds firstnames, Col_B holds last
names
C1: (a name to match...eg John Doe)

This formula returns TRUE if the name is found, or FALSE for no match:
D1: =SUMPRODUCT((A1:A1000&" "&B1:B1000=C1)*ROW(A1:A1000))>0

Or...you could use this ARRAY FORMULA*:
D1: =ISNUMBER(MATCH(C1,A1:A1000&" "&B1:B1000,0))

*Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top