Hi,
I have raw data in the "Data" sheet in the attached workbook.
In B2:F3 in the "Lookups" sheet I would like to create formulae that will return from the Data sheet all of the countries associated with each Region.
Obviously a VLOOKUP won't work as it will only return the first match that it finds.
Can someone please suggest a solution.
Thanks!
Last edited by andrewc; 11-04-2019 at 06:27 PM.
In B2 copied down & across
=IFERROR(INDEX(Data!$C$3:$C$9,AGGREGATE(15,6,(ROW(Data!$C$3:$C$9)-ROW(Data!$C$3)+1)/(Data!$A$3:$A$9=$A2),COLUMNS($B2:B2))),"")
Use this in B2 on Lookups sheet and drag it down and across.
HTML Code:
1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved
Modytrane
Thank you both!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks