Hi all,
I have been using a standard Index,Match,Match formula, works great, however the formula can get very long. I am looking for a way to shorten it, by selecting the array of values I want to be retrieved.
In the spreadsheet example: Cell N7 produces the desired result, but can lead to novel style formulas if I have 30+ records I am trying to sum
Any ideas as to how I can shorten the formula, preferably to be able to select the range M8:M12
Thanks
Bookmarks