Results 1 to 4 of 4

VLOOKUP and MAX/MIN functions

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2009
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    11

    VLOOKUP and MAX/MIN functions

    Hi,

    I would like to know if it is possible to combine the VLOOKUP and MAX/MIN functions into one formula.

    If you see the attached spreadsheet it will make more sense to what I am trying to accomplish. I want the maximum value from my data to be displayed and this is simple with a =MAX(B2:B11) formula and this would display the value 79.3 but this result on its own is meaningless! I need the name of the destination that corresponds to the numerical data to be displayed along with it. After some researching I understand that a VLOOKUP function can provide an output depending on what is inputted but I want the maximum value to be the numerical output with its corresponding text data.
    Attached Files Attached Files

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