Cells with #NA

**Wdan** · 02-18-2009, 04:36 PM

I am using the following formula to automatically fill in cells and have copied the formula to the entire column. The cells that I copied into return #NA. What can I add to this formula to cause the cells with no information to be blank.
Hope this makes sense.

=UPPER(VLOOKUP(A11,AGYNO!$A$1:$B$281,2))

Thanks

**solnajeff** · 02-18-2009, 04:50 PM

Hi

Try the following

Please Login or Register  to view this content.

Regards

Jeff

**VBA Noob** · 02-18-2009, 04:51 PM

Try

=IF(ISERROR(UPPER(VLOOKUP(A11,AGYNO!$A$1:$B$281,2))),"",UPPER(VLOOKUP(A11,AGYNO!$A$1:$B$281,2))

or use conditional formatting (See link)

http://www.contextures.com/xlCondFormat03.html#Errors

VBA Noob

**Wdan** · 02-19-2009, 12:56 PM

Thanks VBA Noob the ISERROR did the trick. I also tried the ISNA formula, but it brought back a FALSE statement.

**VBA Noob** · 02-19-2009, 02:05 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**Liesl** · 05-11-2009, 01:07 PM

in one sheet i have a formula ='Funds Price Check'!Q30/100 . but if the cell it need to look at reads an NA i would like it to be zero. I've tried =if(isna(Funds Price Check'!Q30/100,0) but it doesn't work.

**NBVC** · 05-11-2009, 01:11 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.