Lookup cell value across worksheets

[simonhall]

Hi,

I have a series of worksheets named
Data, 1, 2, 3, 4, 5, etc.

The numbered worksheets each have a particular value in cell A1 that I wish to look up from the "Data" sheet. A cell in the "Data" sheet references the worksheet I wish to look at with the numbers 1, 2, 3, or 4, etc and then return the value from the corresponding sheet in cell A1. I need to be able to change the sheet name and the correct data appear.

This would be similar to a lookup function, except that I need to look across sheets instead of just across rows/columns in one sheet.

Is this possible to achieve using a formula??

Thanks, Simon

[starguy]

Hi,

I have a series of worksheets named
Data, 1, 2, 3, 4, 5, etc.

The numbered worksheets each have a particular value in cell A1 that I wish to look up from the "Data" sheet. A cell in the "Data" sheet references the worksheet I wish to look at with the numbers 1, 2, 3, or 4, etc and then return the value from the corresponding sheet in cell A1. I need to be able to change the sheet name and the correct data appear.

This would be similar to a lookup function, except that I need to look across sheets instead of just across rows/columns in one sheet.

Is this possible to achieve using a formula??

Thanks, Simon

I suppose that cell B5 in Data sheet contains sheet number.

=INDIRECT(B5&"!"&"A1")

when you will change sheet number in cell B5, this formula will fetch value from A1 of that particula sheet.

Regards.

[simonhall]

Thanks,

I can across the Indirect function and wasn't sure how to use it to my advantage. This will work excellently.

Simon