Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel lookups should have a return paramater if not found
The VLOOKUP and HLOOKUP functions in excel return #N/A if the index is not
found in the search list. The parameters should allow you to return zero or "" in these instances. This would remove the need for a great deal of validation tests. Ideally I would suggest the following syntax: =VLOOKUP(A1,Table!A:N,5,NewParameter) Where NewParameter could be a value, null, next (the closest value higher than the search index) or previous (the closest value lower than the search index) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return array formula lookups in to one single cell | Excel Worksheet Functions | |||
If a value is found return a true/false | Excel Discussion (Misc queries) | |||
Arbitrary Lookups - return ALL found values | Excel Worksheet Functions | |||
Return all values found for criteria | Excel Discussion (Misc queries) | |||
Vlookup, return zero if not found | Excel Worksheet Functions |