extracting contact no from one sheet to another in excel

Status
Not open for further replies.

Daljeet Kaur

New Member
Joined
Oct 18, 2018
Messages
4
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,704
Office Version
365
Platform
Windows
Status
Not open for further replies.

Forum statistics

Threads
1,077,780
Messages
5,336,261
Members
399,073
Latest member
fairoos

Some videos you may like

This Week's Hot Topics

Top