| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup - Not Exact Match
I'm using VLookup to find a similar value because the exact match isn't
available. I know that if you put "True" in the formula it will find the next value, but my problem is, is that the next closest match has a letter. How can I make it find the value plus the letter. Example: I'm trying to find 2200218 but the closest match is 2200218A. This is the value I want it to find, not 2200217 or 2200218. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Exact() with VLookup or Match | Excel Worksheet Functions | |||
| Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
| vlookup more than one exact match | Excel Worksheet Functions | |||
| using vlookup to find exact match | Excel Discussion (Misc queries) | |||
| using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions | |||
Threaded Mode
