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.