View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LJ[_2_] LJ[_2_] is offline
external usenet poster
 
Posts: 7
Default Lookup on multiple values

Greetings,

I have a problem setting-up a look-up to return a result based on
multiple values. Using the example below, I need a formula that will
return the time listed columns 1, 2, 3 or 4 while cross-indexing in
the Service column. Example 1 is how I have my spreadsheet with data
set-up and Example 2 is the table array. Thanks in advance for
assistance.

Example 1:
Service Column Category Column Result Column
Acc. 1
2:00:00


Example 2:
Service 1 2 3 4
Acc. 2:00:00 4:00:00 8:00:00 16:00:00
Apps. 4:00:00 8:00:00 16:00:00 32:00:00
App 4:00:00 6:00:00 24:00:00 48:00:00
Avail. 4:00:00 6:00:00 24:00:00 48:00:00