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.