extracting contact no from one sheet to another in excel

[Daljeet Kaur]

I have two sheets of excel one contains name, address ,contact no etc columns
ad another one Contains Name ,address and another columns
there is no any consistency of data
i have to match one sheet each cell of name to another sheet each cell of name if match find then go through address because there is a duplicate's in names


if both match then return the contact no of belonging row

what to do?

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1075721-extracting-contact-no-one-sheet-another.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.