+ Reply to Thread
Results 1 to 4 of 4

Lookup a combination of multiple critera and return a value

  1. #1
    Registered User
    Join Date
    05-03-2020
    Location
    Jubail, KSA
    MS-Off Ver
    2016
    Posts
    2

    Lookup a combination of multiple critera and return a value

    Hi everyone,

    I would like someone to help me out in this.

    The requirement is to match the values (criteria) in two columns and return the corresponding value in the 3rd column. The catch here is that the two columns where the criteria is to be matched can be in any order. Have attached the image below for reference with the required results. Could not attach the excel file (i don't know why).

    Criteria_Combination.jpg

    I am not able to find a way to do this with VLookup.

    Hope its not too difficult an issue. If this problem has been solved elsewhere on this forum, please direct me there..

    Thank you

    Regards,
    Azeem

  2. #2
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    92

    Re: Lookup a combination of multiple critera and return a value

    Open your thread
    Click on "Reply"
    Quick Reply Dialog shows up, enter any pertinent info in there.
    Click on "Go Advanced"
    Scroll down to "Manage Attachments"
    Upload Files from your Computer
    Select the file you want to attach
    Click on the first "Upload"
    then click on "Close this window"
    Click on "Submit Reply"

    That should do it, I guess you may not have Clicked on the first "Upload" as this is a
    common mistake.

  3. #3
    Registered User
    Join Date
    05-03-2020
    Location
    Jubail, KSA
    MS-Off Ver
    2016
    Posts
    2

    Re: Lookup a combination of multiple critera and return a value

    File now attached....


    Thanks Way2020 for the help...
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    11,816

    Re: Lookup a combination of multiple critera and return a value

    Hello smazeem and Welcome to Excel Forum.
    If I understand correctly then the following will yield the expected result (2) in cell E5:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Select E5 > press Ctrl + c keys > Select E11 > press Ctrl + v keys to get 2 in E11 also
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Multiple critera / Partial match lookup
    By johnmitch38 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2019, 01:09 PM
  2. Replies: 0
    Last Post: 01-31-2018, 06:44 AM
  3. [SOLVED] Looking for a combination formula with certain critera
    By gratedane8 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2017, 12:58 PM
  4. If multiple critera matches then return value
    By lordcut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2016, 07:35 AM
  5. [SOLVED] Potential combination of LookUp and DeDupe to create multiple values in a single cell
    By Bwambale in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-25-2016, 08:51 AM
  6. Search named range for multiple matches to critera and return date & values
    By a.mack123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2011, 10:07 AM
  7. multiple array reference with lookup combination
    By wolph42 in forum Excel General
    Replies: 3
    Last Post: 07-22-2008, 07:46 AM

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