Relative reference table lookup and adjustment

It would help us find a solution if you could attach a copy of your workbook instead of the image file.

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

See if this is what you want...
=INDEX($A$2:$A$14,MATCH(H1,OFFSET($A$1,1,MATCH($G$1,$B$1:$F$1,0),13,1),0)+COUNTIF(OFFSET($A$1,1,MATCH($G$1,$B$1:$F$1,0),13,1),H1)-1)

I put the Customer type in G1 and the amount in H7

Try this...

A16 = some type
B16 some point value

This array formula** entered in C16:

=MAX(IF(INDEX(B2:F14,0,MATCH(A16,B1:F1,0))=B16,A2:A14))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.