Compare rows and columns and return a value

[nitiona]

Hi I'm looking for a excel formula for comparing values in a table (row vs column) and return a intersecting value.
For Eg. when we compare value in row C146 (114.3) and value in column J133 (XS), it intersects at 8.56. So the formula should return a value in B4 as 8.56. Attached is the screenshot of the table. Table range is C133:P163.

 

[Peter_SSs]

That sounds a bit vague, but is this what you mean?

=XLOOKUP(114.3,C:C,J:J)

If not, please clarify further.

 

[nitiona]

That sounds a bit vague, but is this what you mean?

=XLOOKUP(114.3,C:C,J:J)

If not, please clarify further.

Hi
actually yellow highlighted columns are for example purpose only.
Basically when i select a value from C colum and a value from any D, E or so on, it should find the intersecting value and return with the value.
Eg. C144 vs G144 = 5.49

 

[Peter_SSs]

Clear as mud to me I'm afraid.