Problem with VLOOKUP
 

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

Problem with VLOOKUP
 

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

Problem with VLOOKUP
 

Yes. My idea is to post the formula so we can properly advise you.
Otherwise, it's just a wild goose chase.

Regards,
Fred.

"Jarek" wrote in message
...
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

Problem with VLOOKUP
 

my first guess is that you need to make your table array absolute by putting
$ in both col and row references, such as $A$2 : $D$100 in the
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup), so that EXcel
won't change your references


--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"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

Problem with VLOOKUP
 

Thank you all for the suggestions.
The problem turned out to be somewhere else (I noticed it on VLOOKUP, but
could have noticed it on any copied function). Somehow the Calculation Option
(Tools) was switched from Automatic to Manual.
--
Thank you again!
Jarek


"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