A1: Joe Smith
A2: Fran Angie
A3: Roth Child
D1: Transfer to Angie Fran
D2: Transfer to Child Roth
D3: Transfer to Smith Joe
I am attempting to use either Index or Match function to reference to the D column cells. They are not in order and the names in the A column can be opposite to that of the D Column. I have attempted the ISNUMBER(Search) array with no success due to the reversed names.
Thank you,
Tricia
Bookmarks