# Merging data from two sheets where match is found

1. ## Merging data from two sheets where match is found

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!

2. ## Re: Merging data from two sheets where match is found

=IF(ISNA(match(A4,Sheet1!A\$2:A\$770,0)),"No",vlookup(A4,Sheet1!A\$2:c\$770,2,FALSE)
and
=IF(ISNA(match(A4,Sheet1!A\$2:A\$770,0)),"No",vlookup(A4,Sheet1!A\$2:c\$770,3,FALSE)

3. ## Re: Merging data from two sheets where match is found

Perfect!!!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1