Using a lookup to find a value but the Index column Changes

[t0m46]

Hey all

I have a Speadsheet that has a Table in that i do a Vlookup from to return a Value based on the reference cell that i input a value in.

what i want to be able to do is that the colum i want to look up the value in isnt always going to be the same column. is there a way to do a Vlookup but have the column index number able to look through the coloumn headders that i will put in and uses a cloumn based on what the headder is, EG: Name,

Also by using a Vlookup the value you enter has to be in the first column. is there a way that that can change column as well

thanks

Tom