| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search and lookup functions
Hello, any help appreciated,
I have values in column A such as 123CRR, 123ABC, 456ZZZ, etc. I want to have a lookup table that contains CRR = this ABC = that ZZZ = something else I need a way to extract or identify the specific text string in column A and then use that value in a lookup table. I know how to use lookup tables when all I am looking up is the entire value in column A. I am looking for a way to extract just the text value and then use that in my lookup table. Thanks very much in advance, bmac |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search and lookup functions
Instead of using:
=VLOOKUP(A1, ...etc you can use: =VLOOKUP(RIGHT(A1,3), ...etc Hope this helps. Pete On Jan 23, 4:12*pm, bmac wrote: Hello, any help appreciated, I have values in column A such as 123CRR, 123ABC, 456ZZZ, etc. I want to have a lookup table that contains CRR = this ABC = that ZZZ = something else I need a way to extract or identify the specific text string in column A and then use that value in a lookup table. I know how to use lookup tables when all I am looking up is the entire value in column A. I am looking for a way to extract just the text value and then use that in my lookup table. Thanks very much in advance, bmac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Helpwith Search/Find functions | Excel Worksheet Functions | |||
| Can you use multiple SEARCH functions in one cell | Excel Worksheet Functions | |||
| Limit to nested IF(ISNUMBER(SEARCH)) functions? | Excel Worksheet Functions | |||
| Wildcard search functions within Vlookup | Excel Worksheet Functions | |||
| Need help using search functions | Excel Worksheet Functions | |||
Hybrid Mode
