Thanks:  0
Likes:  0

# Thread: Look up part of a name in a list of names.

1. I have a list of names:

a. jones
b. smith

I want to look up these names in a table.

The names in the table are:

brian smith

How can I do this? Should I use wild cards?

Thanks for any suggestions!

2. On 2002-04-19 12:42, chadm wrote:
I have a list of names:

a. jones
b. smith

I want to look up these names in a table.

The names in the table are:

brian smith

How can I do this? Should I use wild cards?

Thanks for any suggestions!
Is the table a 1- or 2-column table? And, what do you want to return when "a. jones" is found in the table?

3. The table will likely be 5 columns.

When the name is found, I want it to return the value one column over.

4. On 2002-04-19 13:01, chadm wrote:
The table will likely be 5 columns.

When the name is found, I want it to return the value one column over.
Apparently, "adam jones" in a single cell in the first column of your 5 column table. And your lookup values consist of an initial followed by a dot followed by a last name.

If so, supposing that your table is in B2:F100, insert a new column after next to column B.

In C2 enter and copy down as far as needed:

=LEFT(B2)&". "&RIGHT(B2,LEN(B2)-SEARCH(" ",B2))

Now you can use a straight VLOOKUP, for example:

=VLOOKUP(A1,C2:F100,2,0)

5. On 2002-04-19 13:01, chadm wrote:
The table will likely be 5 columns.

When the name is found, I want it to return the value one column over.
=INDEX(table_range,MATCH(SUBSTITUTE(A1,". ","*"),INDEX(table_range,0,1),0),column_num)

[ This Message was edited by: Mark W. on 2002-04-19 13:29 ]

6. Works Great!

You really are Da Man.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•