I have a matric table that lists all the states with tax conditions.
Condition A Condition B Condition C
NY T E T
TX E E T
I have a another spreadsheet with all those conditions as headers and line items with various states.
If the item for Condition A is in TX then the item is taxable, if not it is exempt then it's 0.
The issue is that I don't want to write 9 combined if statesments (based on the headers). How can I create a more efficient formula?
My column titles are called Headings and all of my data is called alldata on the matrix spreadsheet.