populate a list based on whats a user picks in a cell????

  • Thread starter Thread starter Fab
  • Start date Start date
F

Fab

hello,

o.k. here is my prob....

I have sheet one with the following information.

mon tue wen thr fri sat sun
10% 15% 1% 9% 5% 2% 6%
11% 12% 6% 1% 2% 3% 4%
99% 77% 9% 9% 9% 9% 9%
30% 55% 0% 0% 0% 0% 0%

Now on another sheet i have something like this.

Pick day of week:

values 10%
15%
1%
9%
5%
2%
6%

Now if the user picks mon as day of week. The values will popluate the %
values based on sheet 1 values.

Help pls!!

Fab.
 
Hi
this could be done with INDEX/MATCH. But I'm not sure how you want to
populate the other sheet based on your selection?
 
Back
Top