| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup where text not exact
I want to lookup a text field, but although the field I am looking up against
contains the text in my lookup field, it is not exact so Vlookup is not returning the value, i.e. the field I am using to identify against contains first initial and surname and the sheet I am looking up contains full name. I have tried the True option, but it doesn't work properly for all of the entries. Is there another formula to use. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a text string when the result of VLOOKUP formula is #N/A | Excel Worksheet Functions | |||
| text limit using a vlookup | Excel Discussion (Misc queries) | |||
| VLOOKUP (with text) | Excel Discussion (Misc queries) | |||
| How to get an exact mactch with Vlookup | Excel Worksheet Functions | |||
| VLOOKUP first numerical value (not text) | Excel Worksheet Functions | |||
Threaded Mode
