Problem with VLOOKUP

J

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
 
G

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 A1:D100 by mistake.
 
F

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.
 
F

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top