Afternoon all,
I have a matrix that contains data relating to suppliers, lots and job roles they can undertake. What I need to create is a dynamic supplier list based on this criteria using drop down selectors.
Attached is an example of the data I'm working with.
If you have any queries just give me a shout.
Thanks in advance,
Snook
Try this in E2:
Ctrl Shift Enter
Please Login or Register to view this content.
another way (ordinary formula):
=IFERROR(INDEX('Job Matrix'!A:A,AGGREGATE(15,6,ROW('Job Matrix'!$A$2:$A$107)/(('Job Matrix'!$B$2:$B$107=LOOKUP(9^9,LEFT(MID($C$2,SEARCH("Lot ",$C$2)+4,256),{1,2,3,4})+0))*(INDEX('Job Matrix'!$C$2:$X$107,,MATCH(Selector!$C$3,'Job Matrix'!$C$1:$X$1,0))="Y")),ROWS($1:1))),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Both work a treat, cheers 63falcondude and Glenn Kennedy, much appreciated!
You're welcome!
Glad we could help. Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks