Needing help with Vlookup or if there's a simplier way of doing it

[Dipydawg]

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.

 

[Niek Otten]

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



|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.

 

[Dipydawg]

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


|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.