I am putting a spreadsheet together that will need to select appropriate steel beam sizes based on given criteria. I have a sheet that lists all available sizes and the related properties of each. I would like to pick the lightest size that meets minimum criteria of two or three properties. An additional benefit would be to list the 5 lightest options from the list.
I am trying to use the index, match, and small functions together, but I am struggleing to get it to work. Any advice would be greatly appreciated.
Thanks,
Craig
Bookmarks