Index Match lookup Multiple Criteria

[STEFAWN]

Hello,

How do I look up the Site name, Service level and Service area from the lookup table so the input result is the time.

Thanks
Tawnee

[TABLE="width: 91%, align: center"]
[TR]
[TD]Lookup Table
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Site Name
[/TD]
[TD]Area
[/TD]
[TD]First
[/TD]
[TD]Priority
[/TD]
[TD]Standard
[/TD]
[TD]Two Day A.M.
[/TD]
[TD]Two Day
[/TD]
[TD]Express Saver
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]George
[/TD]
[TD]A1
[/TD]
[TD]8:00am
[/TD]
[TD]10:30am
[/TD]
[TD]3pm
[/TD]
[TD]10:30am
[/TD]
[TD]4:30pm
[/TD]
[TD]4:30pm
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Inland
[/TD]
[TD]A2
[/TD]
[TD]7:00am
[/TD]
[TD]10:00am
[/TD]
[TD]4pm
[/TD]
[TD]10:30am
[/TD]
[TD]4:30pm
[/TD]
[TD]4:30pm
[/TD]
[/TR]
[/TABLE]


[TABLE="align: center"]
[TR]
[TD]Results
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Site Name
[/TD]
[TD]Service Level
[/TD]
[TD]Service Area
[/TD]
[TD]Commitment Time Results
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]George
[/TD]
[TD]First
[/TD]
[TD]A6
[/TD]
[TD]8:00am (need formula here)
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Inland
[/TD]
[TD]Standard
[/TD]
[TD]A2
[/TD]
[TD]4pm (need formula here)
[/TD]
[/TR]
[/TABLE]

 

[Aladin Akyurek]

A1:H3 of Sheet1 houses the look up table.

A1:D3 of Sheet2 houses the results, where A2:C3 is given.

In D2 of Sheet2 enter and copy down:

=VLOOKUP($A2,Sheet1!$A$1:$H$3,MATCH($B2,INDEX(Sheet1!$A$1:$H$3,1,0),0),0)

 

[STEFAWN]

Thank you Aladin

 

[Aladin Akyurek]

Thank you Aladin

You are welcome.