Return value under column header

I am pulling data from a remote database. What is returned is a row of column names and a row of data.

I'd like to use something like vlookup to enter into another cell that does the following:



Lookup from row A4:Z4 for a value in A15 and return the Value in this cell(B15) of the row immediately under A where it finds the match.

So basically go find a column header called customer(which is in A15) and return me the value in row 5 that is in the same column.



Any help is greatly appreciated.

Thanks

Try HLOOKUP

=HLOOKUP(A15,A4:Z5,2,0)

in B15

THANKS! I never even knew hlookup existed LOL...I've always known about VLookup