| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup & exact match
In my worksheet/form a user enters a policy number in B5 to search for
details. B6 holds the vlookup formula which displays their info. But if a non-existing policy is entered in B5, B6 shows the next closest match. How do I force an exact match & give some sort of error message when an invalid # has been entered ? Thanks! =VLOOKUP(B5,List2,2) |
| 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 - Not Exact Match | Excel Worksheet Functions | |||
| Using Exact() with VLookup or Match | Excel Worksheet Functions | |||
| vlookup more than one exact match | Excel Worksheet Functions | |||
Threaded Mode
