VLOOKUP

This is a discussion on VLOOKUP within the Excel Questions forums, part of the Question Forums category; How do I get VLOOKUP to return a blank (instead of a "0") if the target cell is empty?...

1. How do I get VLOOKUP to return a blank (instead of a "0") if the target cell is empty?

2. Am I understanding you correctly, the value you are looking up is there, but the column you want pulled in is blank?

1) You could use an IF formula =IF(VLOOKUP=0,"",VLOOKUP)

2) If the value you are looking up is not present use =IF(ISNA(VLOOKUP.....

I hope this helps.

[ This Message was edited by: Aaron on 2002-10-25 11:04 ]

3. All you have to do is add a CHAR(160).
Assuming you are in cell B1 type the following:

=IF(A1=0;CHAR(160);VLOOKUP(A1;table_arrey;col_index_num;0))

David

4. Thanks to both!
Aaron, your simple solution (#1) worked for my specific example - the "Dumbs" have invaded my brain lately! I should remember how to test for nulls using an IF statement. Thanks.

******** ******************** ************************************************************************>
 Microsoft Excel - VlookupExamples.xls ___Running: xl2000 : OS = Windows 98
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 B2C2B3C3B4C4B5C5B6C6 =

A
B
C
D
E
F
1
Lookup*ValueResultHide*This*Column*Table*refers*to:*F2:G6
2
a33*a3
3
b*
#N/A*c*
4
c*
0*e5
5
d*
#N/A*f8
6
e55*g6
7
******
 Example1 *

[HtmlMaker 2.32] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

6. Thanks for the help, Aladin.

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•