I'm trying to figure out how to lookup row value to match column name and provide the value for that respective column.
Can a formula do the trick?
Cost CC | 1361 | 1014 | 1463 | 6485 | 9010 | 0037 | 5845 | 4400 | 6882 |
6485 | 0 | 0 | 0 | 2000 | 10 | 37 | 20 | 250 | 0 |
1014 | 0 | 25 | 0 | 200 | 100 | 38 | 10 | 78 | 0 |
0037 | 0 | 0 | 0 | 25 | 100 | 39 | 5 | 79 | 0 |
6882 | 0 | 0 | 0 | 50 | 1000 | 0 | 5 | 80 | 500 |
Find from column Cost CC 6485 in column range 1361 - 6882 and return value (in this case it would be 2000).
This is just a sample. My actual file have thousands of rows and at least 40 columns (column name are numbers).
Any help would be appreciated!
Résolu ! Accéder à la solution.
Thank you Ponraj. Can you show me the configuration for the transpose?
Thank you very much!