+ Reply to Thread
Results 1 to 3 of 3

Lookup function problem

  1. #1
    Registered User
    Join Date
    09-10-2015
    Location
    Caringbah, NSW, Australia
    MS-Off Ver
    Office 365
    Posts
    50

    Lookup function problem

    I need help with either a vlookup/hlookup or index/match formula.
    I have a table of values with the column headings as dates.
    In the column after the last value I need to insert the date of the column associated with the maximum value in that row.
    Example:
    Row 11 has dates in each column from J to U
    Row 30 has values (unsorted) in columns J to U
    I wish to insert (using a formula) in cell V30, the date from row 11 that corresponds to the MAXIMUM value in row 30 from columns J to U.
    So, if S30 was the maximum value the I wish to display the date from S11.
    Any ideas on how to do that?
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,220

    Re: Lookup function problem

    Hi USAOz,

    Look at W13 for the formula of:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    that you need to simply pull down.
    Index Match of Max.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Lookup function problem

    Duplicate of https://www.excelforum.com/excel-for...n-a-range.html

+ 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. function.:Lookup Problem
    By hendra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2008, 03:19 PM
  2. LOOKUP function problem?
    By DORI in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-27-2005, 07:50 PM
  3. problem lookup function
    By RagDyeR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  4. [SOLVED] problem lookup function
    By bill gras in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. problem lookup function
    By bill gras in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. Lookup function problem (kg)
    By greencecil in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] problem lookup function
    By bill gras in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. [SOLVED] Lookup Function Problem
    By seve in forum Excel General
    Replies: 9
    Last Post: 02-27-2005, 11:06 PM

Tags for this Thread

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