Not sure this is where this question goes but who knows. What I am attempting to do it search a range of cells for a specific word or words that is found in a different cell. Then take information that is in relation to the first cell and put it in the same relation to the second cell. Just read the example.
In the Example provided what I want, if possible, to have it search the range of First Names in Sheet two for those matching a name in the range from Sheet one, then place the corresponding last name, from sheet one, with the first name on sheet two.
Don't know how complicated that would be, or not at all, but I have been trying to do it for ages and can't figure it out.
Bookmarks