Copying & dragging vlookup cells?
 

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

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

Copying & dragging vlookup cells?
 

Hi

You need absolute references in your formula:

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

Regards,
Per

On 31 Jan., 15:12, Rich wrote:
Heres what i basically need help with :phttp://i590.photobucket.com/albums/ss342/xXxRichMxXx/djfrekHELP.png

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

Copying & dragging vlookup cells?
 

Whenever you are referring the Lookup Range partially in Vlookup then dont
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)
--------------------


"Rich" wrote:

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

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

Copying & dragging vlookup cells?
 

Thankyou so much :)
solved perfectly

"Ms-Exl-Learner" wrote:

Whenever you are referring the Lookup Range partially in Vlookup then dont
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)
--------------------


"Rich" wrote:

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

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

Copying & dragging vlookup cells?
 

You are welcome and thanks for feeding back.

--------------------
(Ms-Exl-Learner)
--------------------


"Rich" wrote:

Thankyou so much :)
solved perfectly

"Ms-Exl-Learner" wrote:

Whenever you are referring the Lookup Range partially in Vlookup then dont
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)
--------------------


"Rich" wrote:

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

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