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.