garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Good Morning
Below is a simplified example of what I am looking for.
Top table is my raw data and my bottom table is my analysis table.
B20 is just a concatenate of B6,C6,C7 to create unique / identifiable refence. C19 will change depending which week it is.
I would like a formula in C20 which will return the value of 3 (in this example). The are long winded ways of me doing this, but perhaps there is a more simple approach as apposed to having to create additional inputs on Raw Data source (Concatenates and Indexing).
Below is a simplified example of what I am looking for.
Top table is my raw data and my bottom table is my analysis table.
B20 is just a concatenate of B6,C6,C7 to create unique / identifiable refence. C19 will change depending which week it is.
I would like a formula in C20 which will return the value of 3 (in this example). The are long winded ways of me doing this, but perhaps there is a more simple approach as apposed to having to create additional inputs on Raw Data source (Concatenates and Indexing).