Reference a fixed cell on different sheets
Hi
you want the 'Indirect' function
Example:
Put "Hello" in Sheet 2, A1
Put "World" in Sheet3, A1
in Sheet1 B1 put "Sheet2!"
in sheet1 B2 put "Sheet3!"
(dont forget the exclamaion mark!!!)
in sheet1 A1
=indirect(b1&"A1")&" "&indirect(b2&"A1)
Ta da
RegMigrant
"Mark Holland" wrote:
Hello,
This hopefully should be easy :) :)
I want to reference a value in a different sheet, but I want the sheet to be
choosen by the contents of another cell.
So in other words, if I have a drop down menu of my Sheet names in A1 - I
want to be able to use this 'kind' of formula in B1, '=A1!B3'. The end result
would be to return the value of B3 from the sheet choosen in A1.
This obviously doesn't work, which is why I need help :)
Any Ideas Please?
Many Thanks
Mark
|