I am having trouble getting my nested formula to work.
Essentially, I have a lookup table called "Score" which is 6 cols x 75 rows.
I need to lookup specific values in different rows/columns.
Example of table:
Index WestCoast EastCoast Central MidWest Southern
1 58 99 72 65 48
2 48 81 55 91 23
I need to lookup a value for a certain index & region & plug 1 value into a cell.
So if my region is Central and Index is 2, my cell populates with 55.
Any help would be greatly appreciated!