document name reference

[RobTalbert]

I want to create a formula which refers to a cell in a different wroksheet. However, I want to point to any number of different worksheets, depending on the value I store in an adjacent cell. For example, I would like to use a pointer to cell A2 in my formula below and have the formula insert the "sh2" so the formulat would have the correct document name. Any way to do this without creating a bunch of nexted if statements?

A1 A2 A3
10 sht2 vlookup(A1, [A2]!a1:c10, 2)

 

[RET79]

Hi, sorry I am in a bit of a rush, but this sounds to me like you need to use the indirect function.

RET79

 

[Aladin Akyurek]

On 2002-04-16 11:48, RobTalbert wrote:
I want to create a formula which refers to a cell in a different wroksheet. However, I want to point to any number of different worksheets, depending on the value I store in an adjacent cell. For example, I would like to use a pointer to cell A2 in my formula below and have the formula insert the "sh2" so the formulat would have the correct document name. Any way to do this without creating a bunch of nexted if statements?

A1 A2 A3
10 sht2 vlookup(A1, [A2]!a1:c10, 2)

=VLOOKUP(A1,INDIRECT("'"&A2&"'!A1:C10"),2)