1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

# Excel Lookup Required

Discussion in 'Business Applications' started by djk85, Jan 3, 2012.

Not open for further replies.

Joined:
Feb 11, 2008
Messages:
3
I am trying to develop a spreadsheet for my team and it relates to Overall KPI and their Personal Score

Overall KPI = STORE
Personal Score = INDIVIDUAL

The company has provided me with a matrix
And I want to make it easier for my team to understand how important is for everyone to be on the same boat

I have uploaded the Excel file

All I require is:
If the Store is on a certain % (CELL D22)
And the Individual is on a certain % (CELL C25:C29)
What would be the exact % of Bonus they will be getting (Cell D:2529)

What is the best formula?

Kind Regards,

File size:
10.6 KB
Views:
64
2. ### bomb #21

Joined:
Jul 1, 2005
Messages:
8,276
A formula is:

=INDEX(\$D\$4:\$I\$15,MATCH(\$D\$22,\$C\$4:\$C\$15,0),MATCH(C25,\$D\$3:\$I\$3))

As Seen On