Index & Match or VLookup based off of Multiple criteria

[JGREEN17]

Hello,

I'm trying to write a formula in cell A2 that will look through columns I:K and will give me the name of a person based on their Title & Department code

I just can't seem to figure it out. Any help would greatly be appreciated

Thank You

Jason

[Limor_OP]

Hi
Try this in A2 and down:
=IFERROR(INDEX($H$3:$H$32,MATCH(C2&B2,$J$3:$J$32&$I$3:$I$32,0)),"")

[JGREEN17]

Hi
Try this in A2 and down:
=IFERROR(INDEX($H$3:$H$32,MATCH(C2&B2,$J$3:$J$32&$I$3:$I$32,0)),"")

It didn’t seem to work. I copied and pasted it and then entered manually twice

[Glenn Kennedy]

belinda's solution was an array formula and needs CTRL-SHIFT-ENTER to set it. This one just needs ENTER:

=IFERROR(INDEX($H$3:$H$32,MATCH(1,INDEX(($J$3:$J$32=C2)*(I$3:$I$32=B2),0),0)),"")

[JGREEN17]

Disregard my last reply. It worked perfectly.

Thank You

Jason