+ Reply to Thread
Results 1 to 2 of 2

Lookup or match function with multiple criteria giving different results

  1. #1
    Registered User
    Join Date
    04-07-2013
    Location
    Lahore
    MS-Off Ver
    Excel 2007
    Posts
    9

    Lookup or match function with multiple criteria giving different results

    Hi,

    I need to formulate a lookup function in cell D17 for my worksheet (attached). If I type GWD in cell B17 and cell B18 is blank, the columns values in range A2:A14 should appear in row-wise order that match the criteria i.e. GWD in range B2:B14.

    If I type GWD in cell B17 and 11 in cell B18, the columns values in range A2:A14 should appear in row-wise order that match the criteria i.e. GWD in range B2:B14 & 11 in range C2:C14.

    Some conditions and desired results are mentioned in workbook.

    I hope you will understand.

    Regards
    Attached Files Attached Files

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Lookup or match function with multiple criteria giving different results

    Using your posted workbook, I can get you most of what you want

    This regular formula begins the horizontal list of Col_A people who match the "Berth at" and "Tenure" criteria
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Copy that formula across through cell P18

    Copy D18:P18 and
    ...paste into D21:P21
    ...paste into D23:P23
    ...paste into D27:P27

    NOTE: That formula can only accommodate ONE of each criteria. Consequently, you'd need to split the Berth at PQA & KPT into 2 separate sections so the formulas can test each separately.

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

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