Hi I am trying to look up a row in Sheets that first is a text match. In this case a row that matches UTAH. And then of those 3 results pick the one with the lowest number. I have tried adding a formula in the supporting lookup but I am not getting anywhere. In the example below I would like to select the 8th row.
THANK YOU!
Best answer by Matt_Boyden
View original