extract value from a table with 2 dynamic value

[AndreaSangalli]

Hello there

I have to extract a value from a table where I have 2 dynamic variables .
The first one is the BARTENDER SHIFT(am/pm/double), the second one is the “SCENARIO”(12/21/22…).

For exemple in the PIC the result will be for the AM 20, PM 30,DOUBLE 50

I cant figure out the way to make the app choose the correct value inside the table

Thank in advance

[dbaum]

I don’t clearly understand what you need to accomplish. Perhaps you need the LOOKUP function.

That said, in case you’re not already aware, the sheet you screenshotted is not necessarily structured to be used as a data source for an AppSheet app. Potentially, that’s the source of whatever obstacle you’re encountering.

[AndreaSangalli]

Thank for reply.

the screenshot original is just to show how the tipOut is working.

in the Appsheet I already restructured the spreadsheet. My goal is to use the table on the right to find out the right percentage. I’m able to select the number under scenario but I can’t figure how make app sheet go through Am/pm/single/ double

for instance in the in the spread sheet formula I’m using a index (match ()match ()) formula to accomplish the job

[dbaum]

@dbaum

Perhaps you need the LOOKUP function.

Potentially, something like embedded within a series of conditional functions. For example:

IFS(
 "AM", LOOKUP(...), 
 "PM", LOOKUP(...), 
 "Single", LOOKUP(...), 
 "Double", LOOKUP(...)
)

[AndreaSangalli]

THANKY VERY MUCH!!!

In stead of LOOKUP I used ANY(SELECT()) it work out the same.