Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Vlookup return 0 when cell is blank
0 views
Skip to first unread message
Paul
Jan 11, 2006, 9:39:02 AM1/11/06
to
Hi,
Would anybody know why a Vlookup formula would return 0 (i.e. Zero) when the
contents of the cell that is referenced by the cell is blank.
E.g the formula is:
=IF($E$12 = "","",VLOOKUP(G22,[Data.xls]DECAP_ALL2!F:X,19,FALSE))
I know the formula is working fine as it reurns the correct result (either
blank or and alpha numeric from from referenced cell) but for some reason
some results are return 0 when I would expect blank
Any help appreciated
Paul
Dave Peterson
Jan 11, 2006, 10:30:14 AM1/11/06
to
=if($e$12="","",if(vlookup(...)="","",vlookup()))
--
Dave Peterson
Kleev
Jan 11, 2006, 12:01:03 PM1/11/06
to
Actually, the reason that sometimes it is returning blank is that it is not
blank. If you look at those cells, most likely you will find that a single
space has been entered (some people erroneously believe that entering a
single space is the same as deleting the contents of the cell.) If the cell
is truly blank, you will see a zero when using vlookup.
blank. If you look at those cells, most likely you will find that a single
space has been entered (some people erroneously believe that entering a
single space is the same as deleting the contents of the cell.) If the cell
is truly blank, you will see a zero when using vlookup.
0 new messages