Employee lookup, index match

**nickmessick1** · 07-03-2013, 11:43 AM

I am having trouble with either a vlookup or an index/match. I have a table of employees and the days they work. I would like to type the employee serial number and have it result in the data in the row of the date the employee is working.

I included an example.

Thanks for the help.

lookup employee.xlsx

**XOR LX** · 07-03-2013, 11:50 AM

Hi,

Enter these array formulas (confirm with CTRL+SHIFT+ENTER, not just ENTER):

In cell I3:

=INDEX($B$2:$B$9,MATCH(H3&"-"&G3,$A$2:$A$9&"-"&$C$2:$C$9,0),1)

In cell J3:

=INDEX($D$2:$D$9,MATCH(H3&"-"&G3,$A$2:$A$9&"-"&$C$2:$C$9,0),1)

Regards