ExcelBanter - How can I make the box remain empty instead of N/A#

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I make the box remain empty instead of N/A# (https://www.excelbanter.com/excel-worksheet-functions/94000-how-can-i-make-box-remain-empty-instead-n.html)

VegasBurger

How can I make the box remain empty instead of N/A#

currently I am using this formula =VLOOKUP(E5,Sheet2!A:D,4,FALSE) in one of
my cells. Now when E5 is empty this cell displays N/A#, how can I change it
to either show a symbol such as - or remain empty?

Thank you

Paul Mathews

How can I make the box remain empty instead of N/A#

To return a dash if E5 is empty, you can do this
=IF(ISBLANK(E5),"-",VLOOKUP(E5,Sheet2!A:D,4,FALSE))

To return a blank if E5 is empty, do this:
=IF(ISBLANK(E5),"",VLOOKUP(E5,Sheet2!A:D,4,FALSE))

"VegasBurger" wrote:

currently I am using this formula =VLOOKUP(E5,Sheet2!A:D,4,FALSE) in one of
my cells. Now when E5 is empty this cell displays N/A#, how can I change it
to either show a symbol such as - or remain empty?

Thank you

CLR

How can I make the box remain empty instead of N/A#

=IF(ISNA(VLOOKUP(E5,Sheet2!A:D,4,FALSE)),"",VLOOKU P(E5,Sheet2!A:D,4,FALSE))

Vaya con Dios,
Chuck, CABGx3

"VegasBurger" wrote:

currently I am using this formula =VLOOKUP(E5,Sheet2!A:D,4,FALSE) in one of
my cells. Now when E5 is empty this cell displays N/A#, how can I change it
to either show a symbol such as - or remain empty?

Thank you

All times are GMT +1. The time now is 07:23 AM.