Results 1 to 7 of 7

Array formula to match value to row and pull row header (multiple occurrences of value)

Threaded View

lbdavis Array formula to match value... 06-18-2020, 10:55 AM
CARACALLA Re: Array formula to match... 06-18-2020, 11:07 AM
XLent Re: Array formula to match... 06-18-2020, 11:33 AM
CK76 Re: Array formula to match... 06-18-2020, 01:13 PM
lbdavis Re: Array formula to match... 06-18-2020, 01:21 PM
CARACALLA Re: Array formula to match... 06-18-2020, 01:26 PM
CK76 Re: Array formula to match... 06-18-2020, 01:34 PM
  1. #1
    Registered User
    Join Date
    06-18-2020
    Location
    Georgia
    MS-Off Ver
    Office 365
    Posts
    2

    Array formula to match value to row and pull row header (multiple occurrences of value)

    I have received data from a survey where companies were asked to nominate up to 5 other companies. I am trying to list the nominated companies and who nominated them. One nominee can be in multiple rows or columns. I have normalized the data and pulled the nominees into a separate column. I am trying to create a formula to search the original list for the nominee, find a match in the row and pull the company from the row header into the new list. I was able to pull a list using Index/Match but if the Nominee was in the column multiple times I only got the first value. In the example Nominee "W" should show that companies "3", "7", and "5" nominated them.

    Thanks in advance
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Array Pull With Transpose Between Two Dates? [Tricky Index/Match Formula]
    By larryg003 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2017, 10:41 AM
  2. Replies: 2
    Last Post: 07-03-2017, 10:09 AM
  3. Replies: 4
    Last Post: 06-30-2015, 03:49 PM
  4. Issue using Index/Match to pull multiple occurrences of "Match" criteria
    By aridfriedman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2014, 11:38 AM
  5. Replies: 6
    Last Post: 04-12-2013, 05:50 AM
  6. Replies: 10
    Last Post: 12-18-2012, 07:59 AM
  7. Replies: 13
    Last Post: 11-25-2011, 04:57 PM

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