| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use VLOOKUP to find part of string?
I am trying to find for example "(3)" in a column of 50 rows where each row
has a name in it. The name for example may be "Jones" in row 1 and "Smith (3)" in row 8. The "(3)" means something to me in the database. I need to seperate each name that is marked by the "(3)" and utilize the information in the next column that corresponds with the "(3)". How do I use VLOOKUP to find part of this string? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change part of string to lower | Excel Worksheet Functions | |||
| Find and replace part of a text string | Excel Discussion (Misc queries) | |||
| copying part of a number string | Excel Discussion (Misc queries) | |||
| Filter on first part of string | Excel Discussion (Misc queries) | |||
| Extract Part of String | Excel Worksheet Functions | |||
Threaded Mode
