Index based formula:
I have a separate sheet with a 2-column Table Index. (Eg: "Reference Sheet Column A" has all 50 States. "Reference Sheet Column B" has the corresponding sales tax for each State.)
On another sheet, I have "Column A" that allows selection of a State from a dropdown list. In "Column B" I have the "base price" input. I need Column C to provide the automatic calculation of the the Total Sales Price (including sales tax).
So I think I need Column C to automatically calculate: Column B * (1 + the index table matching sales tax for the State selected in Column A).
Can someone help with that formula?
Help Article Resources
Check out the Formula Handbook template!