MCadoret
asked on
excel nested vlookup/hlookup
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!
Thanks!
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!
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked like a charm!