View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
oscarcounts oscarcounts is offline
external usenet poster
 
Posts: 8
Default Lookup multi criteria

I have two sheets. The second sheet obtains data from the first sheet. The
value (£) depends on three criteria in the same row. ie Code,Cost centre and
Department.
When all three match the value (£) is returned or if not 0.