on 6/29/2012, joeu2004 supposed :
"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.

Good point! I didn't see the point, though, to even bother with the
VLOOKUP() if there was nothing to look up in A2. Otherwise, if A2 is
empty and column 3 of the lookup range is empty then I expect that zero
will be returned since that is a default when refing empty cells.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion