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.

Thread Status:
Not open for further replies.
Advertisement
  1. djk85

    djk85 Thread Starter

    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:25:D29)

    What is the best formula? :)

    Kind Regards,
     

    Attached Files:

  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,271
    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
As Seen On...

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.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1034414