help with index/match or vlookup/match formula

Hello all! I need help figuring out this formula, ive tried a bunch of index/match, vlookup/match, index/match/match but cant figure out the best one, ideally one i can fill on the top left then drag to populate all the cells. I attached a picture showing what I would like it to do, basically A28 is a dropdown of the 3 options, A29 is an indirect of a28, and based on what A29 says I would like to fill in all the cells to right of it by searching the tables at the top.
So right now its OPTION1:A, I would like to return the values from the boxes at the top under OPTION 1, box titled A. which formula is ideal for this? Thank you in advance all!

sorry, attached is the workbook. thanks!

Try

=OFFSET(B4,MATCH($A$29,INDEX($B$3:$L$18,0,MATCH($A$28,$B$1:$L$1,0)),0)-1,MATCH($A$28,$B$1:$L$1,0)-1)

offset/match/index/match/match? wow you are incredible, it works perfect! thank you so much.

hi try this may help you

http://www.excelforum.com/excel-form...n-formula.html