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
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!