So basically this is what I'm trying to do.

I have a worksheet that has specific column headers e.g A1=Model, B1=Size, C1=Speed etc.

I need to create a formulae that automatically locates the column header and goes through the column (starting at row 2) and searches its corresponding value from a master sheet database which contains all the values.

I already use a vlookup formulae to lookup the value in A2, A3..... which looks like =vlookup(A2,Model!C:D,2,FALSE). The problem is the lookup value has to be in the same column every time (Column A) and I have to manually drag the formulae down to the number of rows that match however many models there are (The rows will change every time but the Column headers will remain the same). Is there a way the I can automatically lookup the values from my Model sheet given a Column with the header Model and every time I change the amount of rows it automatically re adjusts?

E.G. sheet

A
1 Model
2 Ford
3 Dodge
4 Ferrari
5 Porsche
6 Ford

=vlookup(automatically go into Model column and start at row 2,Model!C:D,2,False)
=vlookup(automatically go into Model column row 3,Model!C:D,2,False)
=vlookup(automatically go into Model column row 4,Model!C:D,2,False)
.
.