INDEX SUMPRODUCT to Headers

[chloeky]

Hello excel experts,

Could someone help to solve this:

I'm using INDEX SUMPRODUCT to look up for the headers. However, if the value of the cells are not within the range, it will auto default to one of the headers which i have no clue how to resolve. The desired out outcome should be blank.

Appreciate your help in advance.

Chloe

[AliGW]

Welcome to the forum.

Please attach the workbook (desensitised).

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.