Adding "if blank" statement to an existing VLOOKUP formula

**kala_way** · 01-27-2012, 06:43 PM

I am currently using this VLOOKUP:

=VLOOKUP(A11:A92,'H:\[file name]Sheet1'!$A$90:$B$92,2,FALSE)

this works perfectly, however, I would like to be able to drag the formula down a large column.

When I do, the cells with data in them return the correct numbers, while the cells without a lookup value return N/A.
Then I have to go through the column and delete the N/A's and change them to zeros.

How can I have it return a 0 if there is no value?
Is it 'if blank' ? How do I work that into my formula?

Can I have it return nothing?

Thank you!

**protonLeah** · 01-27-2012, 07:40 PM

=IF(A11="",0,VLOOKUP(A11,'H:\[file name]Sheet1'!$A$90:$B$92,2,FALSE))

**kala_way** · 01-27-2012, 08:50 PM

I tried that and it still returned N/A

**protonLeah** · 01-27-2012, 10:01 PM

Maybe you should post a workbook. That lookup table looks strange, it's only 3 rows by 2 columns.

**grizzly6969** · 01-27-2012, 10:57 PM

This may work for you

=IF(ISNA(VLOOKUP(A11,'H:\[file name]sheet1!$A$90:$B$92,2,FALSE)=TRUE),"",VLOOKUP(A11,'H:\[file name]sheet1!$A$90:$B$92,2,FALSE))

Adding "if blank" statement to an existing VLOOKUP formula

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Adding "if blank" statement to an existing VLOOKUP formula

Re: Adding "if blank" statement to an existing VLOOKUP formula

Re: Adding "if blank" statement to an existing VLOOKUP formula

Re: Adding "if blank" statement to an existing VLOOKUP formula

Re: Adding "if blank" statement to an existing VLOOKUP formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions