Sheet 1 Column A has a list of names to be found in Sheet 2 Column A names.
Here is what I am doing to find out if a matching name is found in sheet 2.
=IF(ISNA(VLOOKUP(A4,Sheet1!A$2:A$770,1,FALSE)),"No","Yes")
But instead of saying "Yes" (that a match was found)... I would like to get the rest of that matching rows data.
For example: Lets say we found a match on the name Peter (Sheet 1 A15). Now in sheet 2 I want my formula to give me Peter's last name which is found in Sheet 1 B15, then Peters middle inital (Sheet 1 C15).
I am just having trouble returning the matching row back to my formula and using that to get more information. Can anyone help?
Thank you!
Bookmarks