+ Reply to Thread
Results 1 to 2 of 2

Lookup Criteria in cell

  1. #1
    Forum Contributor
    Join Date
    02-13-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2015
    Posts
    183

    Lookup Criteria in cell

    I am trying to create a Biggest Loser tracker. I am trying to add job performance metrics into the sheet as an added incentive.

    In my example sheet, on the DATA sheet in cell BJ5, I am trying to add in a formula that looks at Targets 1 and 2 for week 1 (Cells G5 and H5) and determines the respective point value on the Targets sheet.

    *Edit* Also, I am trying to avoid hard coding the criteria into the formula incase I need to change it at some point.

    Let me know if you need any additional information.

    See attached example
    Attached Files Attached Files
    Last edited by sinspawn56; 02-14-2012 at 03:03 PM.

  2. #2
    Forum Contributor
    Join Date
    02-13-2009
    Location
    Indiana
    MS-Off Ver
    Excel 2015
    Posts
    183

    Re: Lookup Criteria in cell

    Is there any additional information that I can provide to help the wonderful folks on this forum help me?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1