How to get a value from another table (use as a range) based on a field

AppSheet AppSheet Q&A
1

I need to find an expression that gives me a result depending on the value of a field filled from the user side.

example:

Number of employees = 53

Cost=??? in this example the result mus

employees table

MIN MAX COST
0 25 2500
26 50 3000
51 200 5000

I tried to use lookup but it didn’t worked

2

Use something like..
ANY(SELECT(Employees[Cost],AND([_THISROW].[NOE]>=[Min],[_THISROW].[NOE]<=[Max])))
NOE = “number of employees”