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.
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.
Select All=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.