If names in 2 cells match names in 2 other cells return valve in another cell

[syndee]

Cell B2 contains Ball
Cell C2 contains Tara
need to compare to
Cell N2 contains Ball
Cell O2 contains Tara

If both names match return value in column 3 (D:D)

Tried this but only seems to compare 1 name. If two people share 1st or last nae the formula doesn't work.
=VLOOKUP(O3&N3,B:I,3,D:D)

Each person can have multiple entries on spreadsheet.

<colgroup><col span="2"><col><col span="2"><col><col span="2"><col><col><col></colgroup><tbody></tbody>

 

[Joe4]

One way around this is to insert a "helper" column, in which you combine the First Name and Last Name fields together (i.e. C2&B2), and use this in the VLOOKUP.

 

[syndee]

One way around this is to insert a "helper" column, in which you combine the First Name and Last Name fields together (i.e. C2&B2), and use this in the VLOOKUP.

Thanks. Figured it out. It works.

 

[Joe4]

You are welcome.