| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#N/A Excel 2003
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
| Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Threaded Mode
