I'm having trouble with how Excel changes blank cells to 0s. I'm using
the vlookup function to merge 2 spreadsheets. My formula is:
=vlookup(A2:A180, Sheet1!A:BQ, 3, FALSE)
The formula works. My problem is how blank cells from the spreadsheet
I'm trying to merge are given 0s in the merged spreadsheet. Someone
please help me with rewriting the formula so that blank cells come up
as blank, and cells with 0 come up as 0.

I'm having trouble with how Excel changes blank cells to 0s. I'm using
the vlookup function to merge 2 spreadsheets. My formula is:
=vlookup(A2:A180, Sheet1!A:BQ, 3, FALSE)
The formula works. My problem is how blank cells from the spreadsheet
I'm trying to merge are given 0s in the merged spreadsheet.

One way:
=IF(your_formula="", "", your_formula)

On 30/06/2012 8:46 AM, zvkmpw wrote:
I'm having trouble with how Excel changes blank cells to 0s. I'm using
the vlookup function to merge 2 spreadsheets. My formula is:
=vlookup(A2:A180, Sheet1!A:BQ, 3, FALSE)
The formula works. My problem is how blank cells from the spreadsheet
I'm trying to merge are given 0s in the merged spreadsheet.

One way:
=IF(your_formula="", "", your_formula)

Hi
Assuming A2 is the reference cell and the formula is in B2..

=IF($A2="","",VLOOKUP($A2, Sheet1!A:BQ, 3, FALSE))

Copy down as required

HTH
Mick.