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.