Reference with multiple criterias

[Juamgv]

Hello team,

I am trying to get specific data based on a combination of 2 inputs. For example if I input data "A" and data "B" on my first and 2nd field bring me the result of that combination on field 3. or inputting data "A" and "C" what would be the result?

What formula can I use? I have been using "ANY" and it does not work. I will send an screenshot of the app and the table.   

Thank you in advance.

[TeeSee1]

You can try the expression below:

SWITCH(
 [Service Type],
 "Interior/Exterior", LOOKUP([Vehicle Type], "Pricing", "Plan", "Interior/Exterior"),
 "Exterior Wash", LOOKUP([Vehicle Type], "Pricing", "Plan", "Exterior Wash"),
 etc.
)

[Steve]

LOOKUP() - AppSheet Help