The problem I always have copying VLOOKUPs is that the table addresses adjust
when I don't want them to.

I forget to use $A$1:$D$100 and use A1:D100 by mistake.
--
Gary''s Student - gsnu200851


"Jarek" wrote:

Hello,
Using a VLOOKUP function in individual cells (B1, B2, B3, B4, etc) I get
expected results.
But when I copy the cell (from B1 to B3, B3, B4), results are not correct,
even though the formula in each cell is correct (I always get the result that
is identical to B1)
Any Ideas?

Thanks!
Jarek