Formula to reference another sheet using a string in a cell
 

I have a bunch of sheets with different names and I have another sheet that
contains cells that gets information from the different persons sheets.

Eg ='Joe Bloggs'!D49

Would be the formula.

I have a sheet set out like the following

Joe Bloggs| 0 | 0 |
John Doe|0 | 0 |

The 0's are refrences to that particular person cell. Rather than typing in
the name in each formula, I'm just wondering if I can use that actual name in
the cell, so instead of ='John Doe'!D49 I could write something like =A2!D49
using the name to look at the relative sheet.

Thanks for any help thrown my way.

Formula to reference another sheet using a string in a cell
 

=INDIRECT("'" & A2 & "'!D49")

Tim



"NateBuckley" wrote in message
...
I have a bunch of sheets with different names and I have another sheet that
contains cells that gets information from the different persons sheets.

Eg ='Joe Bloggs'!D49

Would be the formula.

I have a sheet set out like the following

Joe Bloggs| 0 | 0 |
John Doe|0 | 0 |

The 0's are refrences to that particular person cell. Rather than typing
in
the name in each formula, I'm just wondering if I can use that actual name
in
the cell, so instead of ='John Doe'!D49 I could write something like
=A2!D49
using the name to look at the relative sheet.

Thanks for any help thrown my way.

Formula to reference another sheet using a string in a cell
 

You're a star.

Thanks matey.

"Tim Williams" wrote:

=INDIRECT("'" & A2 & "'!D49")

Tim



"NateBuckley" wrote in message
...
I have a bunch of sheets with different names and I have another sheet that
contains cells that gets information from the different persons sheets.

Eg ='Joe Bloggs'!D49

Would be the formula.

I have a sheet set out like the following

Joe Bloggs| 0 | 0 |
John Doe|0 | 0 |

The 0's are refrences to that particular person cell. Rather than typing
in
the name in each formula, I'm just wondering if I can use that actual name
in
the cell, so instead of ='John Doe'!D49 I could write something like
=A2!D49
using the name to look at the relative sheet.

Thanks for any help thrown my way.