Thread: Table Field Headings Question

I have a table with 10 fields. The poistion of each field changes on a daily basis. Ie what is in cells A1 & A2 today may be located in cells A10 & a6 tomorrow. The data is coming from a 3rd party system that I cannot alter to lock the fields into place that that I have fixed references from which to make a formula.

I am trying to find a way to lock on to the field heading rather than the specific cell in a spreadsheet.

So , I want a formula like the following:

instead of Total = A1+A2,

I need something like:
Total = Part1CalculationColumnField + Part2CalculationColumnField

Is there a way to do this?

How about something like this:

=OFFSET(A2,0,MATCH("header1",$A$1:$F$1,0)-1)+OFFSET(A2,0,MATCH("header2",$A$1:$F$1,0)-1)

I've attached a simple demonstration.