Board index MS EXCEL

Try Again / VLOOKUP without N/A's

Try Again / VLOOKUP without N/A's

Post by Y2Fyb » Sat, 05 Feb 2005 04:17:04


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.
 
 
 
Top

Try Again / VLOOKUP without N/A's

Post by Peo Sjoblo » Sat, 05 Feb 2005 04:30:25

Stay in the same thread

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

--

Regards,

Peo Sjoblom

 
 
 
Top

Try Again / VLOOKUP without N/A's

Post by Ken Wrigh » Sat, 05 Feb 2005 04:36:08

=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 :-)
----------------------------------------------------------------------------
 
 
 
Top

1. [Info-vax] Test post (try, try, try,try again)

2. Test post (try, try, try,try again)

3. Try, Try, Try, again...

4. [Info-vax] Test post (try, try, try again)

5. Test post (try, try, try again)

6. IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP(

7. Try SMSPEC error again without Google.

8. cloud of AS's

9. MSVCR71.dll - trying again....and again....

10. Iexplorer pops up again and again without my launching it

11. please try connection again...again

12. Outlook is trying to think for me again and getting it wrong (again!)

13. installing perl without compiling it again and again

14. Bitblt - OK, I'll try try again

15. I'll try once again - On every boot, Win tries to install IE & tools IE SP1

All times are UTC
Board index