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

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER

Worked like a charm!