=IF(ISNA(VLOOKUP(A1,C1:C100,2,FALSE)),"",VLOOKUP(A 1,C1:C100,2,FALSE))
Regards,
Alan.
"Scott" wrote in message
...
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.