Index, Match, Vlookup, Hlookup help needed

Hi

I'm trying to look up a horizontal value then return one of the cells in that column dependant on a vertical lookup, i've tried Index, match, vlookup & hlookup but only seem to be able to restrict the formula by specifying the column I want the vlookup to occur against. Is there a way of building the formula to have a bit more flexibility so that its not depentant on my stating only look up in column B (for example)? The sheet the data is coming from is something users will paste their data into so i cannot predict which column my summary should be against.

I need to compare two data sets on the same sheet for various companies. Attached is what i'm looking for.

I used the below

=INDEX($B$2:$D$5,MATCH(A10,$A$2:$A$5,0),0)
=INDEX($B$1:$D$1,MATCH(B10,INDEX($B$2:$D$5,MATCH(A10,$A$2:$A$5,0),0),1))

but these specify a column rather than looking up the column header.

can anyone help?

Thanks Example Data.xlsx

brilliant, thank you so much!

apologies for the delay in coming back

thank you for the info, i will ensure i follow them going forward