If your data is in A1:D3 and lookup value [5] in E2 use this formula in F2

=LOOKUP(E2,A2:D2,A1:D1)

As you can see row 3 isn't used, it's not necessary if your ranges are contiguous