I need to search 10,000 rows of data to find the first row where two of the cells in that row match two values in my input data and the time-values in two more cells in that row bracket a third time-value of my input data. I want to take the first positive match, return a fifth output value in the associated row and then repeat this process for the remaining 4,000 lines of input data (so it needs to be automated).
Is VBA the way to go to do this multi-parameter lookup or is there a way to get this done with only Excel functions?
Bookmarks