+ Reply to Thread
Results 1 to 4 of 4

Error with Min and VLOOKUP Formula

  1. #1
    Registered User
    Join Date
    11-24-2013
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Error with Min and VLOOKUP Formula

    Hi there, I'm new to the site and my first post will be about an error I'm having.

    I've got a really simple table that has the grades of a student in 5 lessons, and the name of that lesson. I want to find the lowest, highest and average grade of the student, and display them else where.
    When preforming a max and average function on the range of values, and then VLOOKUP'ing that value from the table to get the lesson name string, it works fine. Although when I do the same with the Min function, it returns an error on the VLOOKUP.. Now when I replace the MIN function with a value (I.e. for the images below, I place the value 35 where the MIN function would go, and it still won't look up 35 in the table correctly.

    Please see the two images below to help you understand more clearly, or use the document attached below.

    Attachment 279772
    Attachment 279773

    Any help or advice would be greatly appreciated.
    Many thanks, Toby.
    Attached Files Attached Files

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Error with Min and VLOOKUP Formula

    The data isn't sorted so add False to the VLOOKUP

    =VLOOKUP(C15,B4:C8,2,FALSE)

  3. #3
    Registered User
    Join Date
    11-24-2013
    Location
    Manchester, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Error with Min and VLOOKUP Formula

    Such a simple fix, how silly of me!
    Thanks Bob :-)

  4. #4
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Error with Min and VLOOKUP Formula

    It's a pleasure, as long as you don't support Man Utd (but you can't, you are from Manchester )

+ 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. Error with Min and VLOOKUP Formula
    By theovencook in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2013, 12:31 PM
  2. Error with VLookup Formula
    By Thatcher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2013, 12:09 AM
  3. [SOLVED] Error in VLOOKUP formula.
    By ebin charles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-14-2013, 09:08 AM
  4. Error in VLookup formula
    By pani_hcu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-30-2009, 02:47 AM
  5. VLookup Formula Error
    By i.beard in forum Excel General
    Replies: 17
    Last Post: 02-12-2009, 04:42 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