| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using VLookup when text isn't an exact match
I am trying to match a list of data using Vlookup with an array that isn't an
exact match. Example, cell may have "red, white & blue" and the array has "red". I want this to return a positive match, not N/A#. Is there a way to do this using Vlookup or some other function? -- Ken K |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exact Match in Vlookup | Excel Discussion (Misc queries) | |||
| vlookup exact match | Excel Discussion (Misc queries) | |||
| vlookup and finding text string that's not an exact match | Excel Discussion (Misc queries) | |||
| VLookup - Not Exact Match | Excel Worksheet Functions | |||
| Using Exact() with VLookup or Match | Excel Worksheet Functions | |||
Threaded Mode
