Forum Discussion
Getting excel to lookup when there are multiple table options
Hi all - working on an excel file to be used at work (hopefully by coworkers as well as myself) and a bit stuck on how to write a formula for this. I have attached an example workbook with simplified...
=INDEX(Box_size,SMALL(IF(H6<=INDIRECT(G6),ROW(A1:A7)),1))You can try this formula along with a few named ranges. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.