Hi Guys, I am trying to use vlookup (or match/index) to return a value in an array but if the number is repeated, the formula I am using always returns the first match it finds. I've put a simplified version of what I mean below:
1 Cat
1 Dog
2 Fish
In the first cell I am using...