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. |
#2
|
|||
|
|||
#N/A Excel 2003
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. "Scott" wrote: 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. |
#3
|
|||
|
|||
#N/A Excel 2003
=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. |
#4
|
|||
|
|||
#N/A Excel 2003
Thank you very much!!
"Alan" wrote: =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. |
#5
|
|||
|
|||
#N/A Excel 2003
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. "Scott" wrote in message ... Thank you very much!! "Alan" wrote: =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. |
Reply |
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) |