+ Reply to Thread
Results 1 to 4 of 4

Look up + Conditions

  1. #1
    Forum Contributor
    Join Date
    03-23-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    201

    Look up + Conditions

    Hi Gurus,

    I would like to seek your expertise once again.
    I'm having trouble of getting the right value for 2 conditions: Records/Hour and Hours

    I want Records/Hour to have a specific value from a range and will reflect on the Incentive field.
    Incentive Range.JPG

    On the Incentive field. I want the value depending on the Records/Hour to be multiplied by the value shown on the Hours.
    Dashboard Incentive.JPG

    If in any case there is one 0 as value to any of the category I want the Incentive field to say "No Incentive"

    I have attached the file, please help me. TIA.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Look up + Conditions

    Hi,

    I can't help thinking you'd be better of using a Pivot Table, with a calculated field for the records/hour.

    See attached
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    03-23-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    201

    Re: Look up + Conditions

    Sir, how do you remove the (blanks) on the Pivot Table?

  4. #4
    Forum Contributor
    Join Date
    03-23-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    201

    Re: Look up + Conditions

    Sorry, I got it now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help combining macros to delete rows on conditions and add data into cells on conditions
    By JayJayGC in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-03-2017, 10:14 AM
  2. [SOLVED] Advanced Filter Between Two Columns all OR conditions (4 conditions)
    By nobodyukno in forum Excel General
    Replies: 2
    Last Post: 02-16-2017, 01:13 PM
  3. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  4. Replies: 6
    Last Post: 04-30-2015, 09:10 AM
  5. [SOLVED] Vlookup - Country conditions (Multiple conditions)
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2013, 11:42 AM
  6. [SOLVED] Text results with two conditions (lookup with two conditions)
    By Davzx in forum Excel General
    Replies: 8
    Last Post: 05-25-2012, 03:08 AM
  7. How to multiple conditions to validate more than 2 conditions to .
    By Bhuvana Govind in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 04:06 PM

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