Convert name and surname in to ID

[bkobal]

Hi

On the left side I have a table with names, surnames and associated ID.

I would like to enter the name (H3) and surname (I3) and the function would return an appropriate ID (J3). See picture.

Please Help.

Thanks!

 

[Dryver14]

The following formula facinates me

=INDEX(E23:E27,MATCH(G23&H23,INDEX(C23:C27&D23:D27,),0))

I never knew you could match more than one thing,

Is there a limit?

 

[bkobal]

=INDEX(E23:E27,MATCH(G23&H23,INDEX(C23:C27&D23:D27,),0))

This function works to.
If i have two persons with same name and surname, function return ID of the first person.

 

[scottylad2]

Hi, I've only ever tried two different items, but I'm guessing there could easily be more as long as the items were on the same rows. Will have a mock up and try later

 

[bkobal]

when i try to solve this problem, it works only in case if there was no persons with same name or surname.
This was my solution:

=IF((COUNTBLANK(H3:I3))>1;"";(IF(((((MATCH(I3;C$2:C$33;0))-(MATCH(H3;B$2:B$33;0))<>0)));"No_ID";(INDEX(D$2:D$33;(MATCH(I3;C$2:C$33;0)))))))