Need Lookup Help Urgently

[Jason]

I am using the HLOOKUP function to find a value on another
sheet that works fine, but then I need to be able to look
at the value which is one column to the right of the first
value that I looked up.I have tried MATCH and INDEX but to
no avail. I need a formula that can lookup a value the
look one column to the right to give the adjacent figure.
Any help kindly appreciated.
Many Thanks In Advance......
P.S. I can't re-arrange the table to just use the VLOOKUP
as it is not practical in this situation.

 

[Peo Sjoblom]

If your hlookup looks like this

=HLOOKUP(B2,Sheet2!A1:J2,2,0)

then you can get the value one column to the right

=INDEX(Sheet2!A2:J2,MATCH(B2,Sheet2!A1:J1,0)+1)