Looking up Data on another sheet

[chacooke]

I was hoping that one of you smart people out there could help out someone that is working a little above his skill set...

Right now, I am using the following formula on a spreedsheat. =average(threed(first:last!o90)). I have this formula on a spreedsheat that is just a monster in terms of size. I wanted to pull this formula off of this sheet and add it to another one. I was wondering if anyone knew of a good look up formulat that I would be able to use instead.

 

[chacooke]

sorry, meant on another workbook not another sheet.

 

[WILFY06]

Hi Chacooke,

try this

='Drive Letter:\folder\[Filename.xls]Sheetnumber'!$columnletter$CellNumber

eg:
='C:\Example\[SeeThis2006.xls]Sheet3'!$D£1

Should Work

Kind Regards,
David

 

[WILFY06]

Hi Chacooke,

try this

='Drive Letter:\folder\[Filename.xls]Sheetnumber'!$columnletter$CellNumber

eg:
='C:\Example\[SeeThis2006.xls]Sheet3'!$D£1

Should Work

Kind Regards,
David