I have the following example where I found the correct SUMPRODUCT formula but I would like to reverse the order i.e.:
In column A I have different names, each of these names has a corresponding value in column B see example below:
The following formula can look up any name entered in C1 (i.e X)...