Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Search Search
Search for:
Tech Support Guy > > >

Excel Lookup Required


(!)

djk85's Avatar
djk85 djk85 is offline djk85 has a Profile Picture
Computer Specs
Junior Member with 3 posts.
THREAD STARTER
 
Join Date: Feb 2008
Location: London, UK
Experience: I understand a little, but not too much in depth :
03-Jan-2012, 05:15 PM #1
Question Excel Lookup Required
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,
Attached Files
File Type: xlsx Example Bonus.xlsx (10.6 KB, 52 views)
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
03-Jan-2012, 07:09 PM #2
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

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


Tags
excel, lookup, matrix, range, retrieve

(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2