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%"