offset function

[soundengineer]

so I'm having a problem with OFFSET

I have this as a formula in a cell
=(AVERAGEIF('Data Logged'!E:E,"=100",'Data Logged'!S:S))/(AVERAGEIF('Data Logged'!E:E,"=100",'Data Logged'!C:C))

I have been told to use offset and match like this
=OFFSET(DataLogged!$A$1,0,MATCH("Throttle Position (SAE) %",DataLogged!$1:$1,0),4000,1)
in place of my 'Data Logged'!E:E

but I cant seem to make it work...

I have even tried to make a defined name for it calling it "Throttle"
but it pops up a file box to pick a file to update the data from??
and I dont know what to do..

right now I just need somebody to help me make this function work correctly


This is the file its in

Removed the File

A15 has the formula in it

I either get a #NAME? or a #VALUE or a #NA no matter what I try and most of my worksheet looses its functionality from this as well...

any help is appreciated

somebody please help me make it work and show me that it works or walk me through it
I will provide an e-mail address if somebody will just do it and send me the file so I can see it and make the rest work from there

Defined names are OK as well...
as long as you tell me what you had to do step by step so I can do it corrrectly

[soundengineer]

heres the example file...simplified to only the things I am trying to make work
sorry its over 100kb...even zipped...

Removed the File

make the formulas work the same with looking up "Throttle Position (SAE) %" in the Data Logged Page
so that no matter what column "Throttle Position (SAE) %" ends up in the formulas still work

[soundengineer]

heres the example file...simplified to only the things I am trying to make work
sorry its over 100kb...even zipped...

Removed the File

make the formulas work the same with looking up "Throttle Position (SAE) %" in the Data Logged Page
so that no matter what column "Throttle Position (SAE) %" ends up in the formulas still work

nevermind...after playing around with it for several hours...I finally got it to work
the key was that Match returned a value..and the offset is based on the starting point being called 0...so I needed (match(stuff))-1 so that when I plugged that into offset..it would give me the right thing..

thanks all