Vlookup and Cells with Formulas
 

I am trying to implement the following vLookup VLOOKUP(B16,'POS
Analysis July06vs05'!C162:AT363,14,FALSE) where the number in column 14
is based upon a formula; lets say K163*O163. When I use the vlookup I
get a result of (0). I tried pasting the values in column 14 instead
of having the formulas but I get the same result.

Thanks for any insight anyone might have.
Neil

Vlookup and Cells with Formulas
 

Try this formula in a helper cell to see which cell address the VLOOKUP is
actually returning....perhaps it really is a zero. When you have a complex
rangename/table address like you have, all things must be exact for VLOOKUP
to work properly.....check and triple check every character in the VLOOKUP
formula.

=ADDRESS(MATCH(C1,N:N,0),2,4)

where C1 is the cell with the VLOOKUP formula
and N:N is the column or range where you are expecting to get the result from

hth
Vaya con Dios,
Chuck, CABGx3




"nejohnso76" wrote:

I am trying to implement the following vLookup VLOOKUP(B16,'POS
Analysis July06vs05'!C162:AT363,14,FALSE) where the number in column 14
is based upon a formula; lets say K163*O163. When I use the vlookup I
get a result of (0). I tried pasting the values in column 14 instead
of having the formulas but I get the same result.

Thanks for any insight anyone might have.
Neil

Vlookup and Cells with Formulas
 

nejohnso76 wrote:
I am trying to implement the following vLookup VLOOKUP(B16,'POS
Analysis July06vs05'!C162:AT363,14,FALSE) where the number in column
14 is based upon a formula; lets say K163*O163. When I use the
vlookup I get a result of (0). I tried pasting the values in column
14 instead of having the formulas but I get the same result.

Thanks for any insight anyone might have.
Neil

Hi Neil,
The third parameter in VLOOKUP (i.e. 14 in you formula) says to Excel from
which column of the search table (i.e. 'POS
Analysis July06vs05'!C162:AT363 in you formula) it has to output the result
in correspondence of the lookup value (i.e. B16 in you formula). So the
output of the formula you posted will be the value in cell P16, because P is
the 14th column of your table. So if the value in P16 is 0, by formula or
just by direct input, you will have 0 as output.

Anyway, I think taht you should use absolute references to set your search
table, because if you copy down across the rows, the references will change,
so you should use something like this:

VLOOKUP(B16,'POS Analysis July06vs05'!$C$162:$AT$363,14,FALSE)

Maybe you should better apply absolute references in the first line in which
you typed the formula...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy