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

G

Guest

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
 
G

Guest

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))
 
G

Guest

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


Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=I34*H34 without N/A 9
how to make the N/A not show in the below formula 3
VLOOKUP - 0 instead of # N/A 8
Returning 0 instead of #N/A when no value is found 8
How do i find last not empty cell in a range 9
Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to 2
vlookup ignoring empty cells 6
IF #N/A ( in a range), "ALERT","OK" 7

Top