Hide #N/A in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Gram123

Thread Starter
Joined
Mar 15, 2001
Messages
1,829
Hello,
I'm using a series of VLOOKUP tables in an Excel sheet, and when there is no data in the sheet, or erroneous data, the lookup fails and shows #N/A.

Can I hide this #N/A error, so the cell remains blank until the user enters a valid code in the adjacent cell?

Ta

Gram
 

Gram123

Thread Starter
Joined
Mar 15, 2001
Messages
1,829
Also, can you make it so you automatically skip certain cells when you're tabbing through data - in the same way that you can set Tab Stop to No in Access?

Gram
 
Joined
Mar 20, 2003
Messages
4,823
Use the following

=If(Iserror(cellref or formula),0,cellref or formula)

Then go to Tools | options | View and uncheck Zero Values in the Window options section
 
Joined
Jun 26, 2000
Messages
7,762
Originally posted by Gram123:
Also, can you make it so you automatically skip certain cells when you're tabbing through data - in the same way that you can set Tab Stop to No in Access?

Gram
The only way I know of doing that is to unlock the cells you want to tab to, and then protect the worksheet. The locked cells will not be "tabable".
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top