#N/A Excel 2003

G

Guest

I am using VLOOKUP in a spreadsheet.

I would like not to see the #N/A in the cells I have the VLOOKUP command set
up in. I searched for a solution but was only able to find a solution that
has you change the color of the font so it gets mixed in with the background
of the cell. That does not work for me because when a user types in a value
(say SCHOOL#1), the field which has the vlookup statements is not visible!

My question basically is, is there a way to hide the #N/A value until there
is REAL data in that cell?

Thank you.
 
G

Guest

Put an IF function around your vlookup. Instead of =vlookup(...), use
=if(isna(vlookup(...)),"",vlookup(...)). In words, if the vlookup returns
#N/A, return a blank instead; otherwise return the results of the vlookup.
 
A

Alan

That can also be:
=IF(ISNA(VLOOKUP(A1,C1:C100,2,FALSE)),"Any Error Message You
Want",VLOOKUP(A1,C1:C100,2,FALSE))
As I'm sure you've realised,
Regards,
Alan.
 

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

Hiding VLookup #N/A 1
#N/A Conditional Formating 2
Set add function ignore #N/A 1
working with #N/A and conditional formating 1
#N/A 5
Remove #n/a in vlookup to sum results 6
Vlookup - N/A 4
#N/A Conditional Formatting affects all cells? 9

Top