Find match, find related cell and return that number

[HelpHelpHelp]

Hi

Please help me find this formula. Attached is simplified sample.

Many thanks

[Pepe Le Mokko]

In R5 enter =INDEX($G5:$P5,1,MATCH(A5,$G$4:$P$4,0)) - Drag down and across

[geoffrey118]

I don't know whether this solves your problem, however, I did get the same results as your example...

Just use the following formula...drag to fill in the other cells...

=HLOOKUP(A5,$G$4:$P$8,2,FALSE)
=HLOOKUP(A6,$G$4:$P$8,3,FALSE)
=HLOOKUP(A7,$G$4:$P$8,4,FALSE)
=HLOOKUP(A8,$G$4:$P$8,5,FALSE)