Multiple Lookups

[brentphillips]

HI,

I am trying to wite a formula that has multiple lookups and multiple results.

In Column A will be a list for 6 names
In column B there is a list of times along each name with only 1 of 3 out comes.

Input required in cell d1 of a name from the list. Depending on the name and time it will result in 1 of 4 location out comes

Example
Sam - 8am - Location 1
Sam - 830am - Location 2
Harry - 8am - Location 3
Harry - 830am - Location 4

So what i am looking for is to type in the name and referrence the time and it will give me the location as the locations are not populated yet.

Not sure which way to approach the solution. Please help

[NBVC]

Not sure I fully understand, but perhaps:

=INDEX(C1:C6,MATCH(1,INDEX((A1:A6=C1)*(B1:B6=D1),0),0))

This will lookup items entered in C1 and D1, and find them in A1:A6 and B1:B6, respecitively and return the corresponding item from C1:C6.