+ Reply to Thread
Results 1 to 3 of 3

lookup and list matches of a ref no with multiple occurrences

  1. #1
    Registered User
    Join Date
    04-14-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    36

    lookup and list matches of a ref no with multiple occurrences

    Hi excel Gurus...

    I'm back for your most valued assistance with a formula.

    I have uploaded a sample file. Sheet 1 is the master list
    W1, W2,W3 and different sheets in the workbook named after their Ref no.s in cell A1

    I need formula in each sheet to lookup the cell value in A1 against the master list (Sheet 1) and list the values of column B in the master list where a column A matches are found but not duplicate the Column B entries. I have started an INDEX match function however it's duplicating the column B results.

    PLease Please Help!

    Many thanks in Advance!

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: lookup and list matches of a ref no with multiple occurrences

    Perhaps something like this? Using array formula

  3. #3
    Registered User
    Join Date
    04-14-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    36

    Re: lookup and list matches of a ref no with multiple occurrences

    Quote Originally Posted by azumi View Post
    Perhaps something like this? Using array formula
    hi azumi an thanks for taking the time to assist. your formula does exactly what I asked and more however, I noticed a small function usage which I've never used but have just looked it up. I'm hoping if possible you could provide me with a brief walk through what the formula is doing so I better understand how to customise it.

    Also, is an array formula the best solution as they are resource intensive and sheet will be massive so didn't want it to bog down?

    Thanks again for you time and much appreciated.

+ 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] Lookup to find multiple occurrences
    By y_not in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-13-2013, 01:40 PM
  2. [SOLVED] one lookup value, multiple matches
    By dev111ski in forum Excel General
    Replies: 1
    Last Post: 05-17-2012, 08:08 AM
  3. Replies: 6
    Last Post: 05-12-2012, 11:40 AM
  4. Replies: 3
    Last Post: 12-10-2009, 06:21 PM
  5. [SOLVED] lookup multiple occurrences of a value excel
    By ckl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-03-2005, 02:06 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