Formulas required for different options selected

[sameer79]

Thanks Glenn

[Glenn Kennedy]

very confusing description. I have no idea why you highlighted F3:F6. They seem to have no role in the calculation...


=(VLOOKUP(C14,$B$3:$G$6,6,FALSE)+SUM(Addons))/$D$2

see dropdown box in C14.

[sameer79]

Dear Glenn
Thanks for your formula.
I am looking for something like a scenario type solution.

I have copy pasted the values under column G which I am expecting for each Sub options.
I have used Columns I K and M only for explanation purpose of different scenarios.

See the new sample attached.
Thanks once again for your time

[Glenn Kennedy]

Changes in the yellow cells, formula in the orange cells. If this STILL isn't right, please post a file containing ONLY the things that are REALLY present in your sheet.

[Shareez Saleem]

Please Login or Register  to view this content.

[bebo021999]

G14 then drag down:

Please Login or Register  to view this content.

[sameer79]

Dear Glenn
I got it worked using your technique
Thanks for your time.

[sameer79]

Dear Bebo
When I paste your formula it gives error.
Can you paste it in my sample and post it please.
Thanks.

[sameer79]

Dear Shareez,
Thanks for your formula.
But it is not what I want as you are looking for the word "Add" which is a generic word.
I have posted a generic sample.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.