Hi Guys,

I have been researching this for the last 3 days without any luck

I have some data and a table range.
the data and range have two common values (pattern & gob grade).
If the pattern and job grade are found, i need to return the entitlement if the "service" fall between the "MIN" & "MAX" range. (see image)

screenshot.jpg

kindly help!!!

Kind regards,
Marvin.