Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing help with Vlookup or if there's a simplier way of doing it
I have 2 worksheets that need to be merged together into one. One
worksheet will be used as my main sheet, the other has the additional information to be merged into the main sheet. I have a column in each spreadsheet that has the item numbers listed...those numbers are the same in each spreadsheet and will be used as my "reference" between the two spreadsheets, however there is data on one sheet that is not on the other that will also need to be merged into the main. I've been trying to use Vlookup to get the data from the second worksheet to merge with the main worksheet but the only information I'm not getting all the data. Any help on if Vlookup is capable of pulling all the data for me or is there a simplier way of merging the 2 worksheets without having to create a macro...each worksheet has approximately 3000 rows of data. I hope my request makes sense...Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing help with Vlookup or if there's a simplier way of doing it
Use MATCH() to find the relative position of your row in the table.
Then follow Chip Pearson's instructions in the section Returning A Row Or Column From A Table In this link: http://www.cpearson.com/excel/TablesAndLookups.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... |I have 2 worksheets that need to be merged together into one. One | worksheet will be used as my main sheet, the other has the additional | information to be merged into the main sheet. I have a column in each | spreadsheet that has the item numbers listed...those numbers are the | same in each spreadsheet and will be used as my "reference" between | the two spreadsheets, however there is data on one sheet that is not | on the other that will also need to be merged into the main. I've | been trying to use Vlookup to get the data from the second worksheet | to merge with the main worksheet but the only information I'm not | getting all the data. Any help on if Vlookup is capable of pulling | all the data for me or is there a simplier way of merging the 2 | worksheets without having to create a macro...each worksheet has | approximately 3000 rows of data. I hope my request makes sense...Any | help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Needing help with Vlookup or if there's a simplier way of doingit
On Feb 21, 5:14*am, "Niek Otten" wrote:
Use MATCH() to find the relative position of your row in the table. Then follow Chip Pearson's instructions in the section Returning A Row Or Column From A Table In this link: http://www.cpearson.com/excel/TablesAndLookups.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in ... |I have 2 worksheets that need to be merged together into one. *One | worksheet will be used as my main sheet, the other has the additional | information to be merged into the main sheet. *I have a column in each | spreadsheet that has the item numbers listed...those numbers are the | same in each spreadsheet and will be used as my "reference" between | the two spreadsheets, however there is data on one sheet that is not | on the other that will also need to be merged into the main. *I've | been trying to useVlookupto get the data from the second worksheet | to merge with the main worksheet but the only information I'm not | getting all the data. *Anyhelpon ifVlookupis capable of pulling | all the data for me or is there a simplier way of merging the 2 | worksheets without having to create a macro...each worksheet has | approximately 3000 rows of data. *I hope my request makes sense...Any |helpwould be greatly appreciated. Thank you for the reply Niek, for some reason this still didn't work...all the data that the MATCH and OFFSET comand that was in the cpearson link you provided only returned me with results of "1" or "0" and the data that was in one of the spreadsheets and not the other wasn't merged in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP needing to match two cells | Excel Worksheet Functions | |||
Novice needing help!!! | Excel Worksheet Functions | |||
NEEDING FORMULA Please | Excel Worksheet Functions | |||
Needing Help Very Bad | Excel Worksheet Functions | |||
student needing help w/vlookup function grading criteria | Excel Worksheet Functions |