Results 1 to 11 of 11

return next value if mutlple values match

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-25-2014
    Location
    India
    MS-Off Ver
    Excel pro plus 2021
    Posts
    186

    return next value if mutlple values match

    hello friends ,
    i am trying to configure formula ,
    thats searches E1 AND F1 , through A and B column , and returns its corresponding value in c column in cell E2 AND E3 AND SO ON....
    but problem rises when column a and b has two or more combination of E1 and F1 value .
    as a example i have attach sample file ...
    Attached Files Attached Files
    Last edited by raj soni; 12-23-2015 at 09:11 AM. Reason: attach sample file

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Vlookup/index/match to return all values that match
    By Asil01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-09-2014, 12:49 PM
  2. [SOLVED] seperating mutlple values in a cell, then adding across the row.
    By JavierME in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 07-27-2014, 10:02 PM
  3. Using Index/Match to return multiple values for one match
    By superboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 06:21 PM
  4. VLOOKUP/INDEX/MATCH to return all values that match
    By lijia00 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 11:56 AM
  5. Replies: 1
    Last Post: 07-03-2013, 12:14 AM
  6. Replies: 2
    Last Post: 11-12-2012, 06:26 AM
  7. Replies: 5
    Last Post: 10-11-2008, 04:01 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