# 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  Register To Reply

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  Register To Reply

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))),"")  Register To Reply

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

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

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

You're welcome!  Register To Reply

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

Glad we could help. Thanks for the rep!  Register To Reply