Picking cell contents from a list

[flashgun]

I'm looking for a way of using a function to read the contents of a cell but that uses as an argument the contents of another cell to determine which cell to look up. Is that possible??

To explain, I've data in lots of different sheets and in each sheet I've data in say B10. I want to write a list that says Sheet 1 B10, Sheet 2 B10, etc, and have a function that allows me to use "Sheet 1 B10" as the argument to tell Excel where to pick the value from.

I know I can going each sheet and pick the value or write it in each cell each time but with the volume of dataI've got that takes time and is prone to error.

I've tried using cell("contents",xxx) and used the list to fill in xxx but that doesn't seem to work.

Any suggestions would be very gratefully received.

Thx

Pete

[Pete_UK]

You would use the INDIRECT function to do this. I can't advise on the particular formula to use as I don't really understand what you want to do - please explain further. It might also help if you attach a sample workbook (the FAQ describes how to).

Hope this helps.

Pete

[samba_ravi]

http://www.excelforum.com/excel-form...heet-name.html
Go through the above thread it may help you

[flashgun]

Here's an example worksheet. I know it's a kind of difficult one to explain but hopefully someone can get the gist.

I've tried using "Address" to show the text string and then cell but that doesn't seem to work.

Any help would be greatly received.

Thanks

Pete

[samba_ravi]

E5=INDIRECT("'"&B5&"'!"&C5)

Please Login or Register  to view this content.

Try this and copy towards down
Note Remove the Space as shown below (Sheet Name should be same there should not be any extra spaces)
Sheet 1 - Sheet1
Sheet 2 - Sheet2
Sheet 3 - Sheet3
Sheet 4 - Sheet4

[flashgun]

It works!!!!
Many thanks!!! Really appreciate it
Cheers
Pete