I have a formula setup to look up a value in another sheet and bring back a
value. Here is my formula in cell J2
=VLOOKUP("PADRES",Scores!K:N,2,0)
It works perfectly. However, there will be multiple times Padres shows up
in the scores worksheet. How do I setup the formula so in cells J3 it skips
the first occurance of Padres and finds the next one. Then J4 finds the 3rd
occurance and so on. Thanks
Bookmarks