Index Match with Multiple Criteria

[adflamm7]

I use vLOOKUP a lot, but haven't gotten into Index Match much. What I'm looking to do is get the column AR in the Sheet "Order Detail" to return the Name of an employee from "EMP List" by cross referencing the Store and Team Member ID. I can't use vLOOKUP because some employees have the Same Team Member ID. They do have different store numbers, however.

So Column AR needs to look at the store number and Team Member ID (both provided in order detail sheet) and return the appropriate name from EMP List. Hope that makes sense. Example below.

https://drive.google.com/open?id=1O6FWGNWQ3OSbi0F-xoHiY6tIBIjWw_jp

Thanks for looking. You guys have taught me a lot in the past 6 months.

 

[mrshl9898]

I'd just add a column (A) to Emp list concatenating the store and team menmber ID

=C2&B2

Then look that up
=IFERROR(VLOOKUP(B2&AB2,'Emp List'!A:D,4,0),"")