+ Reply to Thread
Results 1 to 5 of 5

Lookup score and match against table with condition

  1. 08-04-2013, 09:08 AM #1
    PWinkz
    PWinkz is offline
    Registered User
    Join Date
    05-30-2012
    Location
    Accra, Ghana
    MS-Off Ver
    Excel 2013
    Posts
    61

    Exclamation Lookup score and match against table with condition

    I would like the mark as described in column b4:b7 displayed in cell c10 on the conditions of column c4:c7 depending on the total average score displayed in cell d10.

    I tried using IF function but i got a little confused. Someone Please Help me out.

    I have attached the excel sheet so you understand me clearly.

    Thanks.

    If_conditions_help.xlsx
    Reply With QuoteRegister To Reply
  2. 08-04-2013, 09:28 AM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: IF_Conditions_Help

    With VLookup

    I added the blue cells.

    The result is in the green cell.

    See the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  3. 08-04-2013, 09:29 AM #3
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: IF_Conditions_Help

    Try...

    =LOOKUP(D10,{0,70,80,90},{"Poor","Satisfactory","Good","Excellent "})
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  4. 08-04-2013, 10:40 AM #4
    PWinkz
    PWinkz is offline
    Registered User
    Join Date
    05-30-2012
    Location
    Accra, Ghana
    MS-Off Ver
    Excel 2013
    Posts
    61

    Thumbs up Re: Lookup score and match against table with condition

    Thanks guys, all worked great! You've been of great help....
    Reply With QuoteRegister To Reply
  5. 08-04-2013, 02:09 PM #5
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Lookup score and match against table with condition

    You're welcome…glad you have a workable solution and thanks for the feedback...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match up 2 lines to their values in a table and check condition.
    By stockgoblin42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-26-2013, 10:52 AM
  2. Need to find the highest score and use a secondary score if duplicate high score
    By kattster in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-20-2012, 06:30 PM
  3. Lookup z-score in z-table
    By nguyeda in forum Excel General
    Replies: 10
    Last Post: 12-23-2011, 08:19 AM
  4. Re: Lookup z-score in z-table
    By SimonDorfman in forum Excel General
    Replies: 0
    Last Post: 10-12-2011, 12:43 PM
  5. Lookup Table with Rating Score being a range
    By emel24 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-02-2005, 10:35 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1