Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default formula

Level Low High
1 $140,000 $155,000
2 $125,000 $155,000
3 $115,000 $145,000

How do I get a formula to look up a salary of $130,000 within the low and
high range to place the Level "2" into a cell?