Data match help

[xstillox]

I am trying to figure out the formula that will help with my situation. I am trying to auto populate different options into cells. The ones in green I have figured out. The ones in red i need help with.
I need the formula to look in row A for the "Option" row B "Stage" and column 9 for the Plan, then give me the correct cost for the add on. H1 through L5 is the table range i have my vlookup for B4, B5, B6, and B7. Is this doable in excel?

I

 

[etaf]

not sure how the OPTION is selected

you have 2 tables
H1 to L6
and
A9 to E21

not sure how those are linked together

I dont see any manually entered results - just AUTO

You can do a grid lookup to find the value based on the row and header lookup