match name to entry and place enty in cell

jon gordyn

New Member
Joined
Jan 24, 2005
Messages
5
this board rocks, so far i have found a lot of good resources for using excel.

I have a name on one sheet that needs to be matched with a manager name from sheet B. I would like to use a function to read the name in sheet A and match it to a corasponding manager name in sheet B. followed by placing that manager name in sheet A at a given Cell.

any Ideas

thanks

Jon
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Without some more detail, I can't tell you exactly how, but you could either use the VLOOKUP() or LOOKUP() functions, or an INDEX/MATCH combination. Can you post your sheet for us to look at? (Link at the bottom of every page.)
 
Upvote 0
Dear Jon

I am also looking for the same have you got your answer if yes pl. send it to me also.

have a good day
 
Upvote 0
How about a formula solution instead? Something like this?:
Book1
ABCD
1EmailSupervisorManager
2joe@domain1.comSupervisor1Manager1
3jim@domain2.comSupervisor2Manager2
4pam@domain3.comSupervisor3Manager3
5sue@domain4.comSupervisor4Manager4
6ted@domain5.comSupervisor5Manager5
7ann@domain6.comSupervisor6Manager6
Sheet1


And the source data looks like this:
Book1
ABCD
1EmailSupervisorManager
2joe@domain1.comSupervisor1Manager1
3jim@domain2.comSupervisor2Manager2
4pam@domain3.comSupervisor3Manager3
5sue@domain4.comSupervisor4Manager4
6ted@domain5.comSupervisor5Manager5
7ann@domain6.comSupervisor6Manager6
Source Data


Formula in B2 (copied down) is:
=INDEX('Source Data'!$A$2:$C$7,MATCH($A2,'Source Data'!$A$2:$A$7,0),2)

Formula in C2 (copied down) is:
=INDEX('Source Data'!$A$2:$C$7,MATCH($A2,'Source Data'!$A$2:$A$7,0),3)

Hope that gives you something good on which to build!
 
Upvote 0
you are the MAN!!!! that worded wonderfully and saved me about 2 hours worth of manual data entry

THANK YOU!!!
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,972
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top