ExcelBanter - Hiding VLookup #N/A

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

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

- - Hiding VLookup #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/262169-hiding-vlookup-n.html)

EmilyE

Hiding VLookup #N/A

I am using a VLookup in my spread sheet, however we don't always need every
line that the equation is on. When it's not in use the cell says #N/A. Is
there a way to hide that?

Jim Thomlinson

Hiding VLookup #N/A

While you can use Conditional formattin gto hide #N/A you are better off to
avoid them in the first place...

=if(isna(vlookup(,,,)), "", vlookup(,,,))

there are some better versions of taht type of formula but that will get you
started.
--
HTH...

Jim Thomlinson

"EmilyE" wrote:

I am using a VLookup in my spread sheet, however we don't always need every
line that the equation is on. When it's not in use the cell says #N/A. Is
there a way to hide that?

All times are GMT +1. The time now is 08:40 AM.