If D42 contains the sheetname: SAFT LE Range
Then this should be what you seek to do:
=OFFSET(INDIRECT("'"&D42&"'!A1"),MATCH(Calculator! F41,INDIRECT("'"&D42&"'!B8:B41"),1),0)

Success? Punch it here, click the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Dingerz" wrote:
Thanks for that however I want it to refer to another worksheet. So for
example i have at the moment:
=OFFSET('SAFT LE Range'!A1,MATCH(Calculator!F41,'SAFT LE Range'!B8:B41,1),0)

i want something like this

=OFFSET(INDIRECT(D42,A1),MATCH(Calculator!F41,INDI RECT(D42)!B8:B41,1),0)

I know its incorrect but you get the idea.