Help! I'm using vlookup to merge 2 spreadsheets. My formula is:
=vlookup(A2:A180, Sheet1!A:BQ, 3, FALSE)

I want the actual 0s to come up as 0s and the blanks to come up as blanks. I keep getting 0s when the values are actually blank.