• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

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!
0
MCadoret
Asked:
MCadoret
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Try this file

Saqib
Index.xls
0
 
chwong67Commented:
Use Index and Match function

For example:
=INDEX($A$2:$F$3,MATCH(A8,$A$2:$A$3,0),MATCH(B8,$A$1:$F$1,0))
0
 
MCadoretAuthor Commented:
AWESOME!!  A million thanks!!!  
Worked like a charm!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now