Hello,
I would like to know what the forumla should look like when using a Vlookup with a drop down list where the list of info that needs to appear on sheet 1, is actually being pulled from sheet 2?
Thanks for your time.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Vlookup with a drop down list using different worksheets
0
Discussion
Hi there, Thanks for this.
In this formula.... what is the title of the worksheet where the info from C3:C8 is coming from?
In this formula.... what is the title of the worksheet where the info from C3:C8 is coming from?
Heather Apr 19, '17 at 10:30 am
Answers
0
=VLOOKUP('Ttrx Date'!$K$10, $C$3:$G$8, 4)K10 is the location of your drop-down on another sheet. The lookup range C3:G8 is on the same sheet as the formula.
Discussion
but sir compleate formula may be
=VLOOKUP('Ttrx Date'!$K$10, $C$3:$G$8, 4,0)
=VLOOKUP('Ttrx Date'!$K$10, $C$3:$G$8, 4,0)
Amit Varshney Apr 19, '17 at 12:10 pm
Range Lookup is optional. 0 (= False) is the default. It may be omitted.
Variatus (rep: 4889) Apr 20, '17 at 9:51 am