Hi,
I am trying to find a way to get a lookup so that i can take 2 criteria and lookup against the table in "look up" tab. I have attached a sample excel to illustrate what i am trying to solve.
I have also put in what the correct answer should be (did it manually) to help.
Hoping someone smarter than me can figure it out because i can't seem to get the amount component to work properly.