| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Text and Receive Other Text in Return
Try it with a TRIM around the lookup value:
=VLOOKUP(TRIM(A1),Sheet1!A:B,2,FALSE) There could be extraneous white spaces here and there throwing apparent matches off (this is quite common). And if the above still doesn't do it, then you need to TRIM the vlookup's reference col ie Sheet1's col A as well. Use a helper col to TRIM in Sheet1 (eg in Sheet1, in E1=TRIM(A1), copy down), then copy the helper col and overwrite Sheet1's col A. Success? hit the YES below -- Max Singapore --- "klmiura" wrote: Yes, Eva that is what I have and I receive #N/A for the result...I even made sure they were all spelled exactly the same and in the same upper/lower case. Any other suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup text in a string with wildcard and return a certain value | Excel Worksheet Functions | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| LOOKUP text return text | Excel Worksheet Functions | |||
| lookup a text cell and return text | Excel Discussion (Misc queries) | |||
| Receive #VALUE! when I mix text with dates using SUMPRODUCT | Excel Worksheet Functions | |||
Hybrid Mode
