Vlookup with a drop down list using different worksheets

0

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.

Answer
Discuss

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? 
Heather Apr 19, '17 at 10:30 am
Add to Discussion

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.

Discuss

Discussion

but sir compleate   formula may be

 =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: 2175) Apr 20, '17 at 9:51 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login