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
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