Hi guys,

I have a question that i was wondering if anyone knew the answer to?

I want to create a spreadsheet table of values that are linked other spreadsheets, a condesnsed version... I am not a total amateur and I understand the world of excel links....

However the problem lies in the fact that the source files change format every day, what i need is a formula for each cell (i know...) that can:

1. Firstly find column and row heading titles by looking for part of the title i.e. for a title like 'Occupation' i need a non case sensitive search for 'Occu'.

2. Once colum and row are found, return the intesecting value.

The formulas are needed so all I will have to do, after this is finished, is update the source files and the relevant numbers will be found automatically.

Im sure this is something that can be done with a clever array formula, setup to recognise column and row intersections based on positve returns on search variables, however this one is just outside my capabilities.... HELP