Copying & dragging vlookup cells?

  • Thread starter Thread starter Rich
  • Start date Start date
Hi

You need absolute references in your formula:

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

Regards,
Per
 
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!
 
Thankyou so much :)
solved perfectly

Ms-Exl-Learner said:
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!
Click to expand...
 
Back
Top