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
|