getting ride of #n/a result from vlookup
try this sort of thing:
IF(ISERROR(VLOOKUP(A21,'Paste Tiq'!$A$1:$T$700,7,FALSE)),"
",VLOOKUP(A21,'Paste Tiq'!$A$1:$T$700,7,FALSE))
"Todd F." wrote:
How does one best do away with the #n/a symbol when that is what the vlookup
returns
Is there a way to tell it to return "blank" or a designated value when the
voolkup does not come up with an exact match
note always use "false" - exact match.
Hey I appreciate your time
|