The form I use for ratings has up to 10 runs for each horse but I only want to look at the last 3 for part of the rating. I can use a countifs formula to get what I need from all 10 but I want to look at just the last 3 runs. The runs are in rows for each horse (listed alphabetically) showing the most recent run at the top.

If anyone can help it would be appreciated.

mattio, i may be able to help but need more information, are you able to email me an example of what your after? You may still have my email address, if not I can post it here again.

Hi Josh,

Thanks, I managed to find a solution to return multiple values from a single VLOOKUP which gave me the data I was looking for.

No worries, I was playing with something similar recently. Had a list of distances down 30,000 rows and wanted to sum the profit from each particular distance (i.e. 1000, 1200, etc etc). Took some searching around on google but found a solution. Always amazes me how adaptable Excel can be.

Yeah I am learning new stuff all the time, there are some great sites out there with heaps of info.