Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel formula - ISERROR?
I did a VLOOKUP formula that works but now I have an #N/A and I know how to make it blank by using ISERROR formula. The only problem is that it makes the cell all together blank. So when I want to have it auto populate using the vlookup formula, it stays blank. Almost like the iserror overwrites the vlookup, even though it's all one formula. Anyone ever have this problem?
4 Answers
- Anonymous9 years agoFavorite Answer
Do you have auto calculate turned off? This is set to on by default, so Excel should update when you change the cell. Are you sure you are entering something that is in the lookup range?
To turn on auto calculate, go to the Formulas tab, click on the "Calculations Options" button, then click Automatic. If you have version 2003 or older, it's Tools / Options / Calculations tab.
P.S. make sure what you type in the cell matches the cell that is in the lookup range. There may be a space character after or before the data in the range.
- Greg GLv 79 years ago
Can you post your formula so we can see what is causing the blank cell?
I'm guessing your have something like this:
=IF(ISERROR(VLOOKUP(C1, A1:B10, 2, FALSE)), "", VLOOKUP(C1, A1:B10, 2, FALSE))
The double quotes would result in a blank instead of an error.
Let me know if this is what's causing the blank or not.
- C MastersLv 69 years ago
if you are using Excel 2007 or 2010 I would suggest using IFERROR
=IFERROR(VLOOKUP(A1, C1:D30,2,FALSE),"")
would look for the value in cell A1 in cells C1:C30 and if it finds a match return the value from the same row in column D
if no match is found (resulting in the error #N/A) it would return a blank
hope that helps
