Re: Removing hidden Format,formula preventing V-lookup from pulling data   

I am not sure i fully understand your case, however, i have two
comments on the limitations of the Vloopup function that might help
you.

1st: while using the vlookup function, the cell u r trying to look for
(lookup value) should be in the 1st column (to left) in the "Table
array"
Otherwise, it will return #N/A

2nd: the vloopup function just does not return the value Zero (thus,
it does not keep the cell empty) it rather displays #N/A

try the ISNA combined with an If statament

=If(ISNA(vlookup(A1,B1:C10,2,false)),"",vlookup(A1,B1:C10,2,false))

Hope it was helpful

date: Thu, 2 Jul 2009 13:01:33 -0700 (PDT)   author:   BRO

Re: Removing hidden Format,formula preventing V-lookup from pullin   

To Unknown - same comment as previously - put the question in the body of the 
email.

To BRO -
Just to clarify:  If a lookup table contains a match on the item but there 
is an empty cell in the return column or a zero it returns zero (0).  Since 
your first point says that if the item is not found it returns NA (assuming 
an exact match) this second point is either redundant or incorrect.

-- 
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"BRO" wrote:

> I am not sure i fully understand your case, however, i have two
> comments on the limitations of the Vloopup function that might help
> you.
> 
> 1st: while using the vlookup function, the cell u r trying to look for
> (lookup value) should be in the 1st column (to left) in the "Table
> array"
> Otherwise, it will return #N/A
> 
> 2nd: the vloopup function just does not return the value Zero (thus,
> it does not keep the cell empty) it rather displays #N/A
> 
> try the ISNA combined with an If statament
> 
> =If(ISNA(vlookup(A1,B1:C10,2,false)),"",vlookup(A1,B1:C10,2,false))
> 
> Hope it was helpful
>

date: Thu, 2 Jul 2009 14:23:00 -0700   author:   Shane Devenshire