Hello All,
I encountered a situation that I need your help with a formula to get the result as shown “result” range row J1:X1.
The calculation based on weekly updated table on the left. If found a MATCH number from the “numberID” row J2:X2 in the Category row “A, B, L1A, L2UA, and T” , then the result is combined the Category name in B column with the “Range#” number.
For example in the table below:
The result found in "J1" based on numberID “1” in "J2". If found "1" matching on the left table as in "G3", then result is A5 by combining Category “A” with Range# 5.
If multiple matching results found, then concatenated the result separating by period for each matching number as shown in "O1".
Thank you all for the help.
BDT
<colgroup><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I encountered a situation that I need your help with a formula to get the result as shown “result” range row J1:X1.
The calculation based on weekly updated table on the left. If found a MATCH number from the “numberID” row J2:X2 in the Category row “A, B, L1A, L2UA, and T” , then the result is combined the Category name in B column with the “Range#” number.
For example in the table below:
The result found in "J1" based on numberID “1” in "J2". If found "1" matching on the left table as in "G3", then result is A5 by combining Category “A” with Range# 5.
If multiple matching results found, then concatenated the result separating by period for each matching number as shown in "O1".
Thank you all for the help.
BDT
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
1 | Range#> | R | 1 | 2 | 3 | 4 | 5 | Result> | A5 | B1.L2UA1 | A2.L1A1 | T5 | A3.T2 | A4.L1A5.T3 | A1 | B5.L1A3.T4 | L2UA3 | B3.L1A4 | L1A2.L2UA5.T1 | L2UA4 | B4 | B2.L2UA2 | ||
2 | numberID> | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | ||||||||
3 | Category> | A | 7 | 3 | 5 | 6 | 1 | |||||||||||||||||
4 | Category> | B | 2 | 15 | 10 | 13 | 8 | |||||||||||||||||
5 | Category> | L1A | 3 | 11 | 8 | 10 | 6 | |||||||||||||||||
6 | Category> | L2UA | 2 | 15 | 9 | 12 | 11 | |||||||||||||||||
7 | Category> | T | 11 | 5 | 6 | 8 | 4 |
<colgroup><col><col><col><col span="5"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>