New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

drop down list puliing data from coresponding lists

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

drop down list puliing data from coresponding lists

Postby josephv » Sat Apr 16, 2016 2:36 pm

I have 3 lists (in columns) on a data sheet:
List 1 in Column A: Week ending dates (52 weeks)
List 2 in Column B: Corresponding revenue amount for store 1
List 3 in Column C: Corresponding revenue amount for store 2

On a new sheet from a drop down list of 52 weekending dates in cell (A1) I want be able to select any weekending date and have the corresponding revenue amounts for the stores populate cell B1 and cell C1 as such:
A1 | B1 | C1 |
date list | store 1 rev | store 2 |
01/02/2016 | $10,000.00 | $12,000 |
  • 0

josephv
Rookie
 
Posts: 1
Joined: Apr 16, 2016
Reputation: 0
Excel Version: 2007

Re: drop down list puliing data from coresponding lists

Postby Sisyphus » Sat Apr 23, 2016 3:32 am

This is a job for INDEX and MATCH. Google for INDEX / MATCH to get instruction how to construct the formula and place it in your output cells B1 and C1.
  • 0

Have a great day! :D

Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
Former Moderator
 
Posts: 4454
Joined: Dec 7, 2011
Location: Shanghai
Reputation: 203
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 52 guests

cron