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

Lookup on multiple values
 

Assuming your starting on row 2, and your table is located in range AA1:AE:5
something like this:

=VLOOKUP($A2,$AA$1:$AE$5,$B2,FALSE)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"LJ" wrote:

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