I have a question. here is what i have so far. I want to know if the change
for a specific account meets or doesnt meet the criteria. for example for the
first data i want it to lookup the account number 7400852 in the table and
then see if the change falls in between those values. if it does than it does
not meet the criteria and if it doesn't then it meets criteria. Anyone help
me out?

Table

Account# Description % Decrease $ Increase $
7400700 Housekeeping 25% ($1,000) $1,000
7400852 Disposal 25% ($500) $500
7400853 Inf waste 25% ($800) $1,000
7400854 Cleaning 25% ($1,000) $2,000
7400856 Security 25% ($1,000) $1,000



Data
account change meet criteria?
7400852 1200
7400856 300