RobTalbert
New Member
- Joined
- Apr 15, 2002
- Messages
- 1
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)
A1 A2 A3
10 sht2 vlookup(A1, [A2]!a1:c10, 2)