IF the workbook is open, you could INDIRECT that result.

--

HTH

RP
(remove nothere from the email address if mailing direct)


<Mike Quinn; <SrA; "USAF" <Mike Quinn, SrA,
wrote in message
...
I am trying to make a formula to referance external data with the ability
to
adapt to adding in columns in the external file. I have got the address
function to give me the correct coordinates for the information required,
however, I want it to display the information in the cell I am referancing
and not the actual coordinates.

Formula:
=ADDRESS(333,LOOKUP(A4,'[external file
name]sheet1!'!B$1:$CC$1,COLUMN(1:81)+1),1,1,"#external file name#")

Actual Result:
'[external file name]sheet1!'!$D$333

Desired Results (i.e.):
"80%"