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
Bookmarks