Thread
:
evaluate cell value with sheet name
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
evaluate cell value with sheet name
=INDIRECT($A12&"!"&"A50") in B12
=INDIRECT($A12&"!"&"A60") in C12
Drag/copy down or up if you have more sheet names in column A
Note that A50 and A60 are text and will not increment.
Gord Dibben MS Excel MVP
On Thu, 04 Oct 2007 03:42:03 -0000,
wrote:
I have different sheet names in column A. I would like to use the
sheet value in A to show a value in a specific cell in that sheet.
For example:
A12 has 'Test 1 & 2' (no 's) and I would like cells b12 and c12 to be
'Test 1 & 2'!A50 and 'Test 1 & 2'!A60 respectively. However, I do not
want to hard code the 'Test 1 & 2' text but would rather use the fact
that this string is already available in cell A12.
How can I do this?
Thanks
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben