Try =INDIRECT("'" & A1 & "'!B3")


--
Regards
Dave Hawley
www.ozgrid.com
"Mark Holland" wrote in message
...
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