Problem with VLOOKUP

[Jarek]

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

 

[Gary''s Student]

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 A1100 by mistake.

 

[Fred Smith]

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

Regards,
Fred.

 

[Francis]

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,range_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]

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.