| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
VLOOKUP
For the cells that return no value #NA is shown in the cell. I would like
these cells simply to be blak. How is this done? Please HELP. Thanks |
|
#2
|
|||
|
|||
|
Use ISNA:
so =VLOOKUP(E1,$A$10:$D$13,3,0) becomes =IF(ISNA(VLOOKUP(E1,$A$10:$D$13,3,0)),"",VLOOKUP(E 1,$A$10:$D$13,3,0)) Hope this Helps Rowan "Patrick" wrote: For the cells that return no value #NA is shown in the cell. I would like these cells simply to be blak. How is this done? Please HELP. Thanks |
|
#3
|
|||
|
|||
|
Perfect, thanks Rowan!
"Rowan" wrote: Use ISNA: so =VLOOKUP(E1,$A$10:$D$13,3,0) becomes =IF(ISNA(VLOOKUP(E1,$A$10:$D$13,3,0)),"",VLOOKUP(E 1,$A$10:$D$13,3,0)) Hope this Helps Rowan "Patrick" wrote: For the cells that return no value #NA is shown in the cell. I would like these cells simply to be blak. How is this done? Please HELP. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Question. | Excel Discussion (Misc queries) | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
