S
Scott
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.
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.