| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Error in Part of a Named Range
Perfect! Thanks!!!
"Biff" wrote: OK.... Just change the last argument in the lookup function to FALSE or 0 for short: =IF(N460="","",VLOOKUP(N460,IDNumbers,2,0)) Biff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy named range to powerpoint | Excel Worksheet Functions | |||
| Using a formula to create named range reference | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Hybrid Mode
