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

Lookup Table	A	B	C	D	E	F	G	H
1	Site Name	Area	First	Priority	Standard	Two Day A.M.	Two Day	Express Saver
2	George	A1	8:00am	10:30am	3pm	10:30am	4:30pm	4:30pm
2	Inland	A2	7:00am	10:00am	4pm	10:30am	4:30pm	4:30pm

Results	A	B	C	D
1	Site Name	Service Level	Service Area	Commitment Time Results
2	George	First	A6	8:00am (need formula here)
2	Inland	Standard	A2	4pm (need formula here)

 

[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.