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

[Sergio_Perez_Ca]

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

[AleksiAlkio]

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