Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge? VLookUp? Hmm...
Hi,
I have 2 worksheets. Worksheet 1 has a list of names in Column A with info in Column C. Worksheet 2 has a list of names (the same but fewer names than in worksheet 1) and additional info in Column B. I'd like excel to put the information from Worksheet 2, column B into worksheet 1, column B whenever the names match up. Make sense? If there were numbers, I think I could use an if statement or fiddle around with VLookUp. I'm not too familiar with merge, but this command comes to mind. Example below: Worksheet 1 Column A / Column C Dot Matrix / Barf / LoneStarr / Kellia Meharry Dark Helmet / President Skroob / Worksheet 2 Column A/ Column B Kellia Meharry / {3} President Skroob / {2,0} Dot Matrix / {4} Lone Starr / {4,3,2,1,0} Barf / {4,3,2,1,0} This has been plaguing me for months and I've been doing the work by hand-- ugg. Any guidance is greatly appreciated. "you see that evil will always triumph, because good is dumb." just joking :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge? VLookUp? Hmm...
VLOOKUP() should do the job for you.
Assumptions: names list on sheet2 goes from row 2 down to row 101 name list on sheet1 starts at row 2, so our first formula goes into B2 on Sheet1: =VLOOKUP(A2,Sheet2!$A$2:$B$101,2,FALSE) and fill down column B on sheet1 as far as your name list goes on that sheet. If the list on Sheet2 may grow and you don't want to have to constantly do maintenance on it, you can rewrite the formula as: =VLOOKUP(A2,Sheet2!$A$:$B$,2,FALSE) The penalty is a little longer to finish the task, the benefit is you only have to extend the formula down sheet1 as its list of names gets longer without having to constantly rewrite the formula because the list of names on Sheet2 got longer. "Kellia" wrote: Hi, I have 2 worksheets. Worksheet 1 has a list of names in Column A with info in Column C. Worksheet 2 has a list of names (the same but fewer names than in worksheet 1) and additional info in Column B. I'd like excel to put the information from Worksheet 2, column B into worksheet 1, column B whenever the names match up. Make sense? If there were numbers, I think I could use an if statement or fiddle around with VLookUp. I'm not too familiar with merge, but this command comes to mind. Example below: Worksheet 1 Column A / Column C Dot Matrix / Barf / LoneStarr / Kellia Meharry Dark Helmet / President Skroob / Worksheet 2 Column A/ Column B Kellia Meharry / {3} President Skroob / {2,0} Dot Matrix / {4} Lone Starr / {4,3,2,1,0} Barf / {4,3,2,1,0} This has been plaguing me for months and I've been doing the work by hand-- ugg. Any guidance is greatly appreciated. "you see that evil will always triumph, because good is dumb." just joking :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge? VLookUp? Hmm...
Oops, didn't clean up the 'rewrite' formula enough, should be (for Cell B2 on
Sheet1) =VLOOKUP(A2,Sheet2!$A:$B,2,FALSE) "Kellia" wrote: Hi, I have 2 worksheets. Worksheet 1 has a list of names in Column A with info in Column C. Worksheet 2 has a list of names (the same but fewer names than in worksheet 1) and additional info in Column B. I'd like excel to put the information from Worksheet 2, column B into worksheet 1, column B whenever the names match up. Make sense? If there were numbers, I think I could use an if statement or fiddle around with VLookUp. I'm not too familiar with merge, but this command comes to mind. Example below: Worksheet 1 Column A / Column C Dot Matrix / Barf / LoneStarr / Kellia Meharry Dark Helmet / President Skroob / Worksheet 2 Column A/ Column B Kellia Meharry / {3} President Skroob / {2,0} Dot Matrix / {4} Lone Starr / {4,3,2,1,0} Barf / {4,3,2,1,0} This has been plaguing me for months and I've been doing the work by hand-- ugg. Any guidance is greatly appreciated. "you see that evil will always triumph, because good is dumb." just joking :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup not working to merge workbooks? | Excel Worksheet Functions | |||
help with vlookup to merge two lists | Excel Discussion (Misc queries) | |||
How to Use Vlookup to merge 2 different worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP merge documents, copy-paste special... | Excel Discussion (Misc queries) | |||
VLookup to merge Access Query data into Excel Report | Excel Discussion (Misc queries) |