Checking for data in table

[jgelpi16]

I have a table illustrated as follows:

Data1 Data2 Data3 Data4
Reason1 Val1 Val2 Val3 Val4
Reason2 Val5 Val6 Val7 Val8


Reason3 Val9 Val10 Val11 Val12

I have a value in a text box. I want to check to see if the value is greater than Val1, between Val2 and Val3 or less than Val4. I also have a indicator "1", "2" and "3". If the indicator is "1" I want to check against the vals for Reason1. If the indicator is "2" I want to check against the vals for Reason2, etc.

Any suggestions as to how I can get started on this will be greatly appreciated. I'm not sure DLookup() will work for this case.

[RuralGuy]

I'm going to suggest a User Defined Function (UDF) that accomplishes the task.