Excel- Getting info from a workbook

Microsoft Office excel 2007 home & stude...
August 9, 2010 at 10:16:26
Specs: Windows XP

I am having troubles figuring out a way to search and copy data from one workbook into another. I have 2 spreadsheets that have 1 common column (ID #) and I want the one spreadsheet to the read the ID# from column A and search the second workbook for the same number in column R. Then copy the data in columns 6-8 in the same row as the ID# into the first work in the same row as the ID#... Hopefully this is clear. Can anybody help me with any ideas.

I have contemplated getting excel to copy the complete other workbook into the first one and then deleting them in the end, but I would prefer to avoid it if necessary.


See More: Excel- Getting info from a workbook

Report •

August 9, 2010 at 10:42:56
If you are willing (and able) to duplicate Column R to the left of the data you want to extract, then VLOOKUP should work for you.

e.g. If you duplicate Column R and place it as Column E, this should work to return what is in column F:


If not, then you need to use the "left lookup" technique found here:




Report •
Related Solutions

Ask Question