Issue 109253

Summary:	Enhancemant LOOKUP-functions with optional "N/A-string"
Product:	Calc	Reporter:	user9591 <jaap>
Component:	code	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.0.0
Target Milestone:	---
Hardware:	Unknown
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description user9591 2010-02-14 13:05:19 UTC

I use the Lookup-functions (also 'Match') a lot and I find it complicating to
always check for "N/A" results. The "N/A" result often looks ugly in a
spreadsheet. It makes the formula twice as long when you want to prevent the
"N/A" in a cell (if(iserror(blablabla).

It would be very convenient when an extra parameter could be added to the
lookup-functions: an optional string that is shown instead of the "N/A". I often
would then use "" (empty string) because I don't want to see anything in a cell
when nothing is found.

Example: VLOOKUP(SearchCriterion; Array; Index; SortOrder;
OptionalStringInsteadOf"N/A")

instead of IF(ISERROR(VLOOKUP(SearchCriterion; Array; Index; SortOrder);"Not
found";VLOOKUP(SearchCriterion; Array; Index; SortOrder)))

Would that be possible in the near future...? I hope so!

Comment 1 ooo 2010-02-15 12:45:28 UTC

Actually a use case for IFNA(), see issue 92677.

*** This issue has been marked as a duplicate of 92677 ***

Comment 2 ooo 2010-02-15 12:46:42 UTC

Closing.