View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
poor me poor me is offline
external usenet poster
 
Posts: 1
Default Multiple Column Lookup in Excel 2003

I have a four-column table. Column A contains City. Columns B through D
contain Employee Status (Contractor/Full time/Part time). The data in the
grid contains the corresponding hourly rates. How can I construct a formula
that will find a person's hourly rate based on their City and Employee Status?