Try Again / VLOOKUP without N/A's

[Guest]

My spreadsheet looks as so:

COLA COLB
AK
DD
CC

Would like to have a vlookup in COLB that will not return NA if COLA is
"blank". COL A values are paste-linked from another sheet.

Thank you in advance.

 

[Peo Sjoblom]

Stay in the same thread

=IF(A1="","",Vlookup(........))

 

[Ken Wright]

=IF(ISNA(yourfomula),"",yourfomula)
or
=IF(ISNA(yourfomula),0,yourfomula)