Forum Discussion
Reference Row Data from another Sheet
My company manufacturers a product line with variations of length. I have a workbook with a sheet for production that shows cut-lengths and quantities. It has another sheet with a complete list of ...
=INDEX($E$3:$E$6,SUM(MMULT(TRANSPOSE(N(ISNUMBER(SEARCH(B9,$A$3:$C$6)))),ROW($1:$4))))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.