View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jimmy Jimmy is offline
external usenet poster
 
Posts: 1
Default look-up in a range

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!