+ Reply to Thread
Results 1 to 3 of 3

Look up and return Muliple criteria

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Look up and return Muliple criteria

    Hello

    I need a lookup and return on Mon Scrap Sheet in col a and b, It needs to return the MC in col c and the part number in d.


    it has to be smart enough so it groups with no spaces, as to the expected data in yellow, green, and red

    cheers
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Look up and return Muliple criteria

    Try at A12
    =IFERROR(INDEX(Sheet2!C$1:C$150,AGGREGATE(15,6,ROW(Sheet2!$D$4:$D$150)/(Sheet2!$D$4:$D$150<>""),ROWS(A$12:A12))),"")
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Re: Look up and return Muliple criteria

    FANTASIC Bo_Ry, thanks for your time and effort

+ 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] Muliple Vlookup to return mulitple answers in different rows.
    By pkemps in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-23-2017, 03:58 PM
  2. Using SUMIFs to sum muliple criteria from ranges
    By tominghana in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-20-2015, 11:11 AM
  3. [SOLVED] Return muliple values using Vlookup
    By manthankanabar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-09-2012, 04:12 PM
  4. need to run muliple urls and return there <title>
    By daggerspine in forum Excel General
    Replies: 0
    Last Post: 06-26-2012, 09:04 AM
  5. VBA to find Muliple criteria
    By Anil2007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2009, 02:36 PM
  6. Lookup value in a table and return muliple contiguous cells from a row
    By Thirsty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2007, 03:07 PM
  7. [SOLVED] using muliple functions to return one result
    By tauwnia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2006, 04:50 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