Index Collect  Pulling from one matrix to another.
Whoops! It posted without text. LOL
I've got data that's in a matrix. With Date on the left, and the Product Name in a helper row at the top.
I have an entry form with this layout, and an output form with the exact layout.
I need to match the Date/product to pull the value from the entry form, into a formula in the output sheet, and then run some calculations from there. For now I just need to find the right combination of index/collect to get me the number.
Recommendations for the formula, and the best placement of ranges would be appreciated.
Mockup below. I do have data in columns 15 of both sheets, so I don't think Vlookup will work.
Answers

I don't think you need the helper row since each of your products are on a different column. I would do something like this.
=Index(Collect({Product 1},{Date},[date]@row)
You would just change your Product reference in the next column over to bring in that product in your output sheet.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!