Board index MS EXCEL

#n/a's

#n/a's

Post by Bill Wilso » Sat, 23 Aug 2003 22:47:55


How can I easily get rid of returned cell values of #N/A
without hitting the delete button manually on each cell
when using an VLOOKUP in a spreadsheet.
 
 
 
Top

#n/a's

Post by John Wilso » Sat, 23 Aug 2003 23:09:33

Bill,

The best thing to do is reconstruct your VLookups so that you'll never
get the #N/A.

e.g.
=IF(ISNA(yourlookup),"",yourlookup)
as an example in a formula:
=IF(ISNA(VLOOKUP(D1,A1:B4,2,FALSE)),"",VLOOKUP(D1,A1:B4,2,FALSE))

John

 
 
 
Top

1. cloud of AS's

2. Weird Problem -- Repeating C's and N's

3. Multiline tooltip problem... shows the \n's

4. Is is possible to count the Y/N's in a record?

5. Number of n's in a range

6. 2 fields have embedded \n's, how to get rid of these?

7. deleting empty lines from a variable containing \n's

8. Difference between 2 N's

9. The Three N's Revisited

10. index n's maximun values in an array

11. Mofify data values of n's variables

12. How to change the "N's" in proc report across time

13. What do all the N's mean?

All times are UTC
Board index