extract multiple data based on criteria

Hello all, I have searched and searched and searched and I just cant get what I am trying to do in excel. Please bare with me as I try to explain this the best I can. What I am looking to do is return multiple results based on one value. This is an agricultural based spreadsheet. So I have a column of seed products that I am going to plant for each respective field.

excel example.png

What I want to do at the bottom of this spreadsheet is list out each product horizontally across a row and have excel list each field that matches that seed number variety number. See Picture 2

excel 2 example.png

From what I can tell is some sort of array formula must be used here to be able to do what I want to do. Is there anyone out there than can tell illustrate how to do?

I have attached my spreadsheet if anyone is willing to create the formula for a few to get me started?

Thank you for looking.

Would a pivot table work for you? If there is a 1 on the column it means that the variety is in that field.

With some VBA, I could take it a step further and list the field names. Most will have 1 or 2 - Variety 64-34 will have 58.

I changed your title to something more descriptive of your problem

Try this ARRAY formula...
=IFERROR(INDEX($B:$B,SMALL(IF($J$2:$J$74=K$79,ROW($A$2:$A$74)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Then copy down and across as needed

You need to start the ROWS() function back at $A$1:A1

Happy to help

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)