Hi,

I am looking for a way to move the vlookup along column at a time when i drag the formulae down (not across).
So basically i have got a table of data and have transposed the headings.
I want to do a vlookup for the items running down the rows to the table with those headings making up different columns.

After looking up that row item now in a verticle column, i'd like to find the highest number from that item.

For the vlookup i used =VLOOKUP($AL$3&$AM$3,$A:$AD,5,0) then i had to change the 5 to a 6, then 7, then 8 and so on manually for each row.
My formulae to find the highest number for this vlookup item is =large(E:E,1) but i want to find the highest number for each item, so will need to manually change each row formulae to F:F, G:G, H:H. - There must be a way to make the columns change as the formulae is dragged down each row

Any help is apreciated

TIA