| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -_- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 -_- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 -_- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 -_- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 -_- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas by dragging fill box | Excel Discussion (Misc queries) | |||
| copying/dragging a formula to adjacent cells in Excel | Excel Discussion (Misc queries) | |||
| Dragging/Copying Lookup Formulas | Excel Discussion (Misc queries) | |||
| Can you have fixed cell reference when dragging/copying formulae? | Excel Discussion (Misc queries) | |||
| Dragging/copying formulas | Excel Discussion (Misc queries) | |||
Hybrid Mode
