Home |
Search |
Today's Posts |
#1
|
|||
|
|||
get rid of #N/A in a VLOOKUP
I need to replace the #N/A values to be blank within a VLOOKUP formula. How
do I do this? I've tried the following but excel doesn't seem to like it: =IF(ISBLANK(VLOOKUP($A6,'Sept 9'!$A$1:$U$47,14,FALSE),"",(VLOOKUP($A6,'Sept 9'!$A$1:$U$47,14,FALSE)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |