Results 1 to 5 of 5

Lookup two column for matches and return largest values from third column

Threaded View

  1. 06-13-2017, 12:23 AM #1
    abulkhairi
    abulkhairi is offline
    Registered User
    Join Date
    03-15-2017
    Location
    Doha, Qatar
    MS-Off Ver
    2013
    Posts
    48

    Lookup two column for matches and return largest values from third column

    Good morning everyone,

    I need a formula that will lookup two ranges for matches and return list of largest values from the third range.

    Please have a look at the attached sample spreadsheet. Many thanks.
    Attached Files Attached Files
    Last edited by abulkhairi; 06-13-2017 at 01:56 AM.
    Reply With QuoteRegister To Reply
« 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] 2 matches, search and return column values
    By madnezzsg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2015, 04:10 PM
  2. [SOLVED] Return value in that column/row when value in that column matches column header in tab 1
    By bwmuhich in forum Excel General
    Replies: 3
    Last Post: 02-11-2014, 12:41 PM
  3. [SOLVED] Lookup Multiple Values in column A (return one value) against column B & C, sum its values
    By bjnockle in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-08-2013, 11:47 AM
  4. lookup formula to return data where column header matches
    By tim-harrison in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-06-2013, 12:58 AM
  5. Formula to find all matches in column A and return cells from column C
    By GenericPat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2012, 04:56 PM
  6. [SOLVED] What formula to use for matches in column and return the sum of all match values in adjace
    By mkmed in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-23-2012, 12:56 PM
  7. [SOLVED] Return sum of values in column when matching and also when Row matches input
    By Dave855 in forum Excel General
    Replies: 3
    Last Post: 11-24-2011, 07:21 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