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!
Solved! Go to Solution.
Thank you Ponraj. Can you show me the configuration for the transpose?
Thank you very much!