excel: if value is x then get value from cell y

I am populating cells from one excel file to another which is a Master file.

Here is how I am doing it:

First I check the name of the column, if correct, then I pull the value below it

=IF('path\[filename.xls]Sheet'!Y$13="Share", 'path\[filename.xls]Sheet'!X14, "")

PROBLEM: its difficult to check the name of the column because new columns are constantly added to this file. The only thing static is the row 13.

Question: Is there a way I can find a column called "Share" without using vba code? I guess I could have millions of IF statements?