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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
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.)
 

ashvin_1

New Member
Joined
Jan 25, 2005
Messages
5
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
 

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237

ADVERTISEMENT

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!
 

jon gordyn

New Member
Joined
Jan 24, 2005
Messages
5
you are the MAN!!!! that worded wonderfully and saved me about 2 hours worth of manual data entry

THANK YOU!!!
 

Forum statistics

Threads
1,148,274
Messages
5,745,797
Members
423,974
Latest member
highvoltageacdc

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
Top