Use HLOOKUP. It works the same as VLOOKUP only horizontaly.

=HLOOKUP(A9,A1:E2,2,0)

In VLOOKUP you define the column_index_number but in HLOOKUP you define the
row_index_number.

--
Biff
Microsoft Excel MVP


"acss" wrote in message
...
New to excell and i would like to utilize vlookup to avoid repetitive
steps.
I have the formula for a two column list =VLOOKUP(A9,A1:B7,2,FALSE) but
not
sure how to configure going horizontal like from A1 TO E1 can someone
assit
please?