This is a screenshot of the problem I shifted over from my original work. Note that some of the cells on the original Piece are in fact merged together. Also the cells C6:C13 are not merged so I can select just those whole numbers. The same is true for D14:P14EXCEL PROBLEM 04:14.jpg
I think this is the answer given to me by Steve the fish:
=INDEX((D6:I13,K6:P13),MATCH(G2,C6:C13,0),LOOKUP(G3,{30,60,90},{1,3,5}),1+(B1="offshore wind"))
Bookmarks