If or possibly VLookup formula help

Hi, trying to get it so the green boxes will auto calculate from the table and the current scores. Thank you in advance

Hi LRGy,

Can you please include the expected output?

Regards,

Hi, added the expected outcome below. Thanks

Originally Posted by LRGy

Hi, added the expected outcome below. Thanks

Hi,
I am really not sure about your logic

Hi

Sorry I will give more detail.

Column's ABCDE, depending on the numbers in the "Current Scores" cell, I need it to put the Points number in the Green box.

i.e. In cell D18, as the current score is 70% (cell D16) is will be zero, if the current score cell had 85% it would have 4 points in the green box.

The Current Score boxes for each area (ABCDE) change depending on other factors but I want to calculate what the Points are from the matrix table for each column.

I want the green boxes to show the current number of points in each area.

I hope that explains it more but if you need more info please let me know.

Thanks

Is that you want?

Formula:

=SUMPRODUCT($B7:$B11,D7:D11)/SUM($B7:$B11)

Hi
Your data must be sorted in ascending order and without empty rows.
Use

Formula:

=IFERROR(INDEX($J$7:$J$9,MATCH(L16,L$7:L$9,1),1),0)

where J7:J9 are 3, 4 and 5
L7:L9 are 80%, 85%, 90%.

You can copy these to the right.
see the file Book1 (17).xlsx
Regards

Thank you Jose - that is perfect