looking up information

Microsoft Microsoft excel 2007 (pc)
May 1, 2010 at 21:26:27
Specs: Windows Vista
What command do I use to look up data in a specific cell in an Excel file and transfer that data to a different Excel file cell?

See More: looking up information

May 2, 2010 at 04:21:46

As those who respond are all volunteers, it is customary to ask for help, rather than just state what you want.

You also need to remember that no one can see your data or your setup of workbooks etc.

With so little information to go on, the best I can suggest is to look at the VLOOKUP() and HLOOKUP() functions. Look at the Help files for these functions and see if they will do what you want. If not or if you cannot get one of them to work, please send a response to this post and include as much detail as possible about what you want to do, what data is involved and where it is stored.

The term look up data usually implies finding data in one range of cells based on the value in another cell.
If you just want a link to a specific cell, where you already know which cell contains the data, then just select the source cell and copy it. Go to the destination cell (in the other Workbook in your case), and right-click the cell and select 'PasteSpecial...' and click the 'Paste Link' button.
You will get a formula something like this


In this example the destination worksheet cell will display the contents of cell A1 on 'Sheet1' in the Workbook 'Source.xls'.


Report •

May 2, 2010 at 10:03:10
Thanks Humar,

I appreciate your reply and information. I tried to keep my request simple yet understandable.

Your latter suggestion was the solution I needed. I am creating a file that will then link to many other files that have data I simply need to have copied into the destination file but need the destination data to be automatically updated if the source file/data is changed.

Again, many thanks - prior to asking for assistance I searched many sites, etc on the net with no success.

If I can help anyone in the future I will.

Report •

May 2, 2010 at 10:25:16
Glad to have been of assistance.

The main workbook containing the links should ask if you want links updated when it is reopened.



Report •
Related Solutions

Ask Question