| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup question if item isn't in table
How can I change a VLOOKUP formula to provide a set response if the item
being searched for in the VLOOKUP is not in the table? I have a formula that looks up a part number entered into column B and fills in column F with data if the part number entered in column B is in my table. =IF(B64="","",VLOOKUP(B64,ProductLookup,8,FALSE)) If B64 isn't in the ProductLookup table, I want the column F to default to Hdwr/Sftwr rather than #N/A. Thanks, Nancy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup - can I set my formula to fill in date if item isn't in ta | Excel Discussion (Misc queries) | |||
| Vlookup/Pivot table question | Excel Worksheet Functions | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Item | Excel Discussion (Misc queries) | |||
Threaded Mode
