trader10518
New Member
- Joined
- Jul 3, 2015
- Messages
- 36
Hi guys,
Is it possible to achieve the following in excel:
I select cell A1, which has a specific reference number. This cell/number corresponds to B1:K1 data set. Similarly, A2 corresponds to B2:K2 data set, and so on.
Separately, there is a formula in cell M1, which uses the data set based on a selected reference number.
I click on any reference number in column A, and a formula in cell M1 uses the corresponding data set. I mean data changes on each selection, just by clicking on a cell within a single column.
Sound possible on not?
Thanks,
Arthur
Is it possible to achieve the following in excel:
I select cell A1, which has a specific reference number. This cell/number corresponds to B1:K1 data set. Similarly, A2 corresponds to B2:K2 data set, and so on.
Separately, there is a formula in cell M1, which uses the data set based on a selected reference number.
I click on any reference number in column A, and a formula in cell M1 uses the corresponding data set. I mean data changes on each selection, just by clicking on a cell within a single column.
Sound possible on not?

Thanks,
Arthur