Using a control cell, how can I return the specified value from a list of cells?
If I enter "4" in B1 it returns "88"
If I enter "5" in B1 it returns "5"
Thanks!
If I enter "4" in B1 it returns "88"
If I enter "5" in B1 it returns "5"
Book2 | ||||
---|---|---|---|---|
A | B | |||
1 | Instance | 4 | ||
2 | Items | 88 | ||
3 | ||||
4 | Day | Items | ||
5 | 1 | 12 | ||
6 | 2 | 6 | ||
7 | 3 | 2 | ||
8 | 4 | 88 | ||
9 | 5 | 5 | ||
10 | 6 | 1 | ||
11 | 7 | 7 | ||
12 | 8 | 0 | ||
13 | 9 | 3 | ||
14 | 10 | 6 | ||
15 | 11 | 4 | ||
16 | 12 | 8 | ||
17 | 13 | 7 | ||
18 | 14 | 16 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A6:A18 | A6 | =A5+1 |
Thanks!