Hi there everyone,
I really need an Excel formula or macro (ideally copy/paste since my VBA is not great) that lets you change the index and lookup array based on the question identifier. So essentially looking at data below, I want my index to change from C2-C4 to C7-C9 based on the identifier in B1 (Q1) and B6 (Q2). I also want my lookup array to change from B2-B4 to B7-B9 across columns on an output sheet.
If anyone could help - that would be really appreciated!!
Thanks,
Reema
<tbody>
</tbody>
I really need an Excel formula or macro (ideally copy/paste since my VBA is not great) that lets you change the index and lookup array based on the question identifier. So essentially looking at data below, I want my index to change from C2-C4 to C7-C9 based on the identifier in B1 (Q1) and B6 (Q2). I also want my lookup array to change from B2-B4 to B7-B9 across columns on an output sheet.
If anyone could help - that would be really appreciated!!
Thanks,
Reema
A | B | C |
1 | Q1 | |
2 | 0 | No change |
3 | 1 | Increase |
4 | 2 | Decrease |
5 | ||
6 | Q2 | |
7 | 0 | High |
8 | 1 | Same |
9 | 2 | Low |
10 |
<tbody>
</tbody>