HELP!!!!!!!!!

P

PKS

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.
 
Z

zvkmpw

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)
 
V

Vacuum Sealed

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top