# Formula to evaluate a matrix and return a supplier list

1. ## Formula to evaluate a matrix and return a supplier list

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.

Snook

2. ## Re: Formula to evaluate a matrix and return a supplier list

Try this in E2:

``Please Login or Register  to view this content.``
Ctrl Shift Enter

3. ## Re: Formula to evaluate a matrix and return a supplier list

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))),"")

4. ## Re: Formula to evaluate a matrix and return a supplier list

Both work a treat, cheers 63falcondude and Glenn Kennedy, much appreciated!

5. ## Re: Formula to evaluate a matrix and return a supplier list

You're welcome!

6. ## Re: Formula to evaluate a matrix and return a supplier list

Glad we could help. Thanks for the rep!

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

#### 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