willemeulen wrote:
I want to do a Hlookup which has to return the value from the row it's
standing in.

=HLOOKUP(L3,Sheet4!B2:AE35,????,FALSE)

L3 gives a code which is on top of the lookup table, the answer can be
found by returning the value in the row.

Another option would be index/match function like this:

=INDEX(Sheet4!B3:Z55,MATCH(L3,B3:B55,0),MATCH("ROW ",B3:Z3,0))

If it's not possible to refer to the row I could create an extra column
(which I hide) to use in the index match function.

:o:



Something like this should work (assuming I'm understanding you correctly):

=INDEX(Sheet4!$B$2:$AE$35,ROW()-1,MATCH(L3,Sheet4!$B$2:$AE$2,0))

You may need to adjust the "-1" depending upon what row you are putting this
formula in.

If this doesn't work correctly for you, something more than "didn't work" (see
your response to Jarek Kujawa) will be necessary to provide more assistance.