blank cell return vs. a 0
"GS" wrote:
=IF(LEN(A2),VLOOKUP(A2,Sheet1!A:BQ,3,FALSE),"")
Salimian wrote: "I want the actual 0s to come up as 0s and the blanks to
come up as blanks". I think Salimian is referring to the result of the
VLOOKUP.
Your formula would work if the result of VLOOKUP were coming from column 1
(kinda useless!).
But in this case, it is coming from column 3. The cell in column 3 might be
empty even if A2 is not, and vice versa. So it is not sufficient to test
A2.
|