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