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

Use Index and Match function

For example:
MCadoretAuthor Commented:
AWESOME!!  A million thanks!!!  
Worked like a charm!
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