Forum Discussion

josh smith's avatar
josh smith
Copper Contributor
May 03, 2018

Find text in the same row as a specific value?

 

We use excel to produce horse shows. We already use conditional formatting to break down the different divisions (time differences) between riders. I am wondering if there is a function or formula that will allow me to pull the current leading riders of each divisions and their times? I have attached a screenshot of my current sheet. Essentially I want to find the times in Column F that match the 4 division times in K1, 2, 3, and 4 and then pull the rider from Column B that ran each of those 4 times over to L1, 2, 3, and 4. I thought I had it figured out with the VLOOKUP function but it isn't always accurate whenever the fastest time changes which in turn changes the other 3 division times. Help?

Resources