Hey guys,
I am using the following formula.
=INDEX($I$4:$I$85,MATCH(B881&" "&C881,$H$4:$H$79,0))
Column B Part of the name: Mattamy-
Column C second part of the name: James place
Column H has the entire name (first and last)
The index worked for some, but not for all of the names. When I...