Hi,
=IF(A131,B8,IF(AND(A115,A1<31),B7,B6))

"Jimmy" wrote:

A1 is a user-entered value for # of employees.

I have a 35 row tiered rate sheet based on number of employees. What
is the best way to look-up A1 and match it to the correct range-row.

Ex:

A1=33

1-10 $5
11-15 $8
16-30 $12
31-50 $15

Thanks!