ExcelBanter - Do not display "#N/A" result

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Do not display "#N/A" result (https://www.excelbanter.com/excel-discussion-misc-queries/219829-do-not-display-n-result.html)

tbrownusa

Do not display "#N/A" result

Is there a way to hide the "#N/A" result in a VLOOKUP calculation when the
result is not possible?

Fred Smith[_4_]

Do not display "#N/A" result

The standard was is:
=if(isna(vlookup(....)),"",vlookup(.....))

If you have XL2007, you can use:
=iferror(vlookup(....),"")

Regards,
Fred.

"tbrownusa" wrote in message
...
Is there a way to hide the "#N/A" result in a VLOOKUP calculation when the
result is not possible?

All times are GMT +1. The time now is 02:25 AM.