Copying & dragging vlookup cells?

[Rich]

Heres what i basically need help with
http://i590.photobucket.com/albums/ss342/xXxRichMxXx/djfrekHELP.png

Thanks for helping guys this one has really stumped me -_-

 

[Per Jessen]

Hi

You need absolute references in your formula:

=VLOOKUP(Sheet2!C9,Sheet3!$A$4:$B$6,2)

Regards,
Per

 

[Ms-Exl-Learner]

Whenever you are referring the Lookup Range partially in Vlookup then don’t
forget to protect the Lookup Range with $ (dollar) symbols instead of
allowing the formula to move on to some other range.

Create your formula like the below:-
=VLOOKUP(Sheet2!C9,Sheet3!$A$4:$B$6,2,0)

Remember to Click Yes, if this post helps!

 

[Rich]

Thankyou so much
solved perfectly

Whenever you are referring the Lookup Range partially in Vlookup then don’t
forget to protect the Lookup Range with $ (dollar) symbols instead of
allowing the formula to move on to some other range.

Create your formula like the below:-
=VLOOKUP(Sheet2!C9,Sheet3!$A$4:$B$6,2,0)

Remember to Click Yes, if this post helps!

 

[Ms-Exl-Learner]

You are welcome and thanks for feeding back.