I'm trying to take two shorter(A/B) columns (last name/first name) and compare with two longer (D/E) columns (last name/first name). On the second set of columns there is a date attached (F). If the search finds a match can it put the corresponding next to the name in the first set (C). I am not an excel master and have been looking into this for way to long with no luck. Is it a combo of a vlookup and match? Help I'm kinda clueless.
<tbody>
</tbody>
A | B | C | D | E | F |
Smith | John | Doe | John | 8/15/16 | |
Davis | Sam | Smith | Chris | 8/15/16 | |
Patterson | Corey | Barnes | Sally | 8/15/16 | |
Ferguson | Tim | Hall | Kim | 12/8/15 | |
Johnson | Ryan | 12/8/15 | |||
Smith | John | 12/8/15 | |||
Morb | Dustin | 12/8/15 | |||
Joseph | Harry | 5/19/17 | |||
Davis | Sam | 5/19/17 | |||
Davis | Laura | 5/19/17 | |||
Rose | Jim | 5/19/17 |
<tbody>
</tbody>