Thank you for yor reply.
I have tried implementing this, see below, but it does not seem to work. excel is not saying there is an error in the formula it just returns an N/A.
=VLOOKUP(D4,Summary!A6:EI148,VLOOKUP("LOOK FOR ME", Summary!A6:EI6,MATCH("ISIN",Summary!A6:EI6,0),FALSE))
D4 is the name on the current sheet I wish the first vlookup to return a value for.
Summary is the sheet name im searching on.
A6:EI148 is where all of my information is contained in summary.
A6:EI6 is the row with the column titles in in summary.
Does the vlookup in the middle of the first vlookup return the number of the column ?