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 |