+ Reply to Thread
Results 1 to 2 of 2

Combining formulas: V-lookup and large numbers

  1. #1
    Forum Contributor
    Join Date
    09-23-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    346

    Combining formulas: V-lookup and large numbers

    Afternoon guys,

    At the moment the work book I am using is fairly huge and things are getting more and more complicated. At the moment I am using two sheets:

    The GRADE SHEET: where the students actual grade is inputted
    The POINT SHEET: where I turn the grade into a numerical value, as I need to work out the student's best 8 point results.

    What I would like to do is combine the following formulas, so I can remove the extra point sheet:

    =IFERROR(VLOOKUP(Grades!B2,LOOKUP!$A$1:$B$23,2),"") - turns the grade into a number

    =SUM(LARGE(B2:K2,{1,2,3,4,5,6,7,8})) - this then adds up the best eight points.

    Any ideas would be greatfully appreciated.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Combining formulas: V-lookup and large numbers

    Try these array formulas in 'Grades' sheet

    In L2
    Please Login or Register  to view this content.
    In M2
    Please Login or Register  to view this content.
    Confirm with Ctrl+Shift+Enter and not just Enter

    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

+ 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