Hi Folks,

In the "Lookup" tab (see attached) I am trying to use an Index & Match formula to return a date from the "Dbase Export" tab, based on the column headings defined in the "Reference" tab.

For example;
On the reference tab, we've assigned the milestone "Milestone_date2" the heading IFS (depending on the project these milestones can change based on client requirements, hence the need for this to be dynamic).

The index & match formula I have so far determines the header to search for. All I need to do now is include a formula that uses this header and converts it to a searchable column array.

Hope this makes sense. The attachement should be pretty self explanatory.

column lookup.xlsx