Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting Excel Data from One Sheet to Another....
Hey Guys,
I have the following Excel problem at work and I am not sure how to solve it. Here is the low down: Excel Sheet #1 Data (First line is the header - [Person and Job]) Person Job --------------------------------------- Fred ? Fred ? Sam ? Kevin ? Kevin ? Julie ? Excel Sheet #2 Data (First line is the Header - [Person and Job]) Person Job --------------------------------------- Fred Mop Boy Julie Hostess Sam Burger Man Kevin Manager Now here is the situation that I have. Based on the how the "Person" Column corresponds to the "Job" Column in Excel Sheet #2, I want to populate the "Job" column in Excel Sheet #1. I am unsure about how to go about this automatically. I have a large amount of data that I need to do this for and it would be a lot of work to do this manually by hand. Can anyone help me out? After I am done populating the "Job" Column in Excel Sheet #1 it should look like this: Excel Sheet #1 Data (First line is the header - [Person and Job]) Person Job --------------------------------------- Fred Mop Boy Fred Mop Boy Sam Burger Man Kevin Manager Kevin Manager Julie Hostess Thanks, Robin |
#2
|
|||
|
|||
On sheet 1, cell B2, use this formula
=VLOOKUP(A2,Sheet2!$a$2:$b$50,2,false) "Robin" wrote: Hey Guys, I have the following Excel problem at work and I am not sure how to solve it. Here is the low down: Excel Sheet #1 Data (First line is the header - [Person and Job]) Person Job --------------------------------------- Fred ? Fred ? Sam ? Kevin ? Kevin ? Julie ? Excel Sheet #2 Data (First line is the Header - [Person and Job]) Person Job --------------------------------------- Fred Mop Boy Julie Hostess Sam Burger Man Kevin Manager Now here is the situation that I have. Based on the how the "Person" Column corresponds to the "Job" Column in Excel Sheet #2, I want to populate the "Job" column in Excel Sheet #1. I am unsure about how to go about this automatically. I have a large amount of data that I need to do this for and it would be a lot of work to do this manually by hand. Can anyone help me out? After I am done populating the "Job" Column in Excel Sheet #1 it should look like this: Excel Sheet #1 Data (First line is the header - [Person and Job]) Person Job --------------------------------------- Fred Mop Boy Fred Mop Boy Sam Burger Man Kevin Manager Kevin Manager Julie Hostess Thanks, Robin |
#3
|
|||
|
|||
Check the Vlookup() function in Help;
That should do ya, HTH "Robin" wrote in message om... Hey Guys, I have the following Excel problem at work and I am not sure how to solve it. Here is the low down: Excel Sheet #1 Data (First line is the header - [Person and Job]) Person Job --------------------------------------- Fred ? Fred ? Sam ? Kevin ? Kevin ? Julie ? Excel Sheet #2 Data (First line is the Header - [Person and Job]) Person Job --------------------------------------- Fred Mop Boy Julie Hostess Sam Burger Man Kevin Manager Now here is the situation that I have. Based on the how the "Person" Column corresponds to the "Job" Column in Excel Sheet #2, I want to populate the "Job" column in Excel Sheet #1. I am unsure about how to go about this automatically. I have a large amount of data that I need to do this for and it would be a lot of work to do this manually by hand. Can anyone help me out? After I am done populating the "Job" Column in Excel Sheet #1 it should look like this: Excel Sheet #1 Data (First line is the header - [Person and Job]) Person Job --------------------------------------- Fred Mop Boy Fred Mop Boy Sam Burger Man Kevin Manager Kevin Manager Julie Hostess Thanks, Robin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) |