Index Match on Multiple Criteria

[msnyder1112]

Alright. I need some help.
I'm familiar with vlookups, and index,matches but I can not get this to work.


I have a workbook with 2 sheets, Sheet1 and Sheet2.
Sheet 1 has 11 columns. Only 3 that I care about. Name, ID Group, IDmin and IDmax.
Sheet 2 has 6 columns. 3 that I care about aswell... Dept, IDGroup and ID.


What I'm trying to do is match up Name on Sheet1 to Sheet2, according to the IDGroup and ID...
However, the tricky part is, when we enter the ID, we enter them as a range on Sheet1.
So,
Sheet1 looks like this.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]GroupID[/TD]
[TD]IDmin[/TD]
[TD]IDmax[/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD]1234[/TD]
[TD]0000[/TD]
[TD]9999[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1234[/TD]
[TD]0000[/TD]
[TD]9999[/TD]
[/TR]
</tbody>[/TABLE]


Sheet2 looks like this.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Dept[/TD]
[TD]GroupID[/TD]
[TD]ID[/TD]
[/TR]
[TR]
[TD]1000056[/TD]
[TD]1234[/TD]
[TD]1458[/TD]
[/TR]
[TR]
[TD]1000056[/TD]
[TD]1234[/TD]
[TD]1854[/TD]
[/TR]
</tbody>[/TABLE]


I want to add a column on Sheet2 called Name, to lookup the IDGroup and ID number to tell me who the ID is. We have several different Group IDs, so that would need to be included.

 

[msnyder1112]

Sorry, Sheet1 would read like this...
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]GroupID[/TD]
[TD]IDmin[/TD]
[TD]IDmax[/TD]
[/TR]
[TR]
[TD]Matt[/TD]
[TD]1234[/TD]
[TD]0000[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1234[/TD]
[TD]1501[/TD]
[TD]9999[/TD]
[/TR]
</tbody>[/TABLE]