Excel Question

[bryce]

I want to do a VLOOKUP formula, but I want the value to be looked up to be nothing, a blank cell in other words. (I know it sounds weird, but I'm running a query, and one of the fields in this query may be blank for some rows, and I want to sum up one of the columns in the query for all of my 'blanks.' So I'm essentially combining a SUMIF formula with the VLOOKUP.)

I've tried referencing a blank cell, or using "", '', " ", ' ', and any number of other assortments to look up, but the result is always #N/A...

Anyone know how to remedy this?

Thanks in advance.

[Buzzbee]

Originally Posted by bryce

I want to do a VLOOKUP formula, but I want the value to be looked up to be nothing, a blank cell in other words. (I know it sounds weird, but I'm running a query, and one of the fields in this query may be blank for some rows, and I want to sum up one of the columns in the query for all of my 'blanks.' So I'm essentially combining a SUMIF formula with the VLOOKUP.)

I've tried referencing a blank cell, or using "", '', " ", ' ', and any number of other assortments to look up, but the result is always #N/A...

Anyone know how to remedy this?

Thanks in advance.

This might be a dirty way to do it, but it might work:

IF(ISBLANK(VLOOKUP(A17,A:B,2,FALSE)),"Blank",A17)


If column 2 {Cell B17 in this example} contains a blank, the vlookup will return the value "Blank" whereas if it isn't blank, it will return the value in A17.

You can change "Blank" to be 0 if you want, or whatever value you choose.

Hope this helps.

[gottimd]

You can also use "=IF(ISNA(" like the below example.