fuzzy match search

[david gabra]

Hi
Can any one help me to get this to work.
It throws up an errors all the time
Reference
https://stackoverflow.com/questions...a-column-and-offset-to-sum-that-grouped-range
I do see the error - I thought I followed instructions step by step
Thanks
David.

 

[GraH - Guido]

Hi david gabra, you did upload a .xlsx-workbook. This does not support VBA.

From the reference, did you copy the function from part 1 solution? It is required in part2.
Did you change the first row counter (it starts at 7), while your data starts in D1.
The sheet name is also hard coded. In your workbook it is "Sheet1" and not "Name".
Then it seems to work. See attached.