Try Again / VLOOKUP without N/A's
 

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.

Stay in the same thread

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

--

Regards,

Peo Sjoblom


"carl" wrote in message
...
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.

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"carl" wrote in message
...
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.