function returning blank on running

FindMD is set at the end, equal to Result. Result is set in one and only one place, inside an If . . . If construct, and it's set equal to a value in degrees!B2:B250.

Are you sure any cell in degrees!A2:A250 equals chkname? For the heck of it, add the following immediately before your 2nd For statement.

Please Login or Register  to view this content.

If this statement suspends execution, then no cell in degrees!A2:A250 matches chkname. In which case a likely cause would be trailing spaces in degrees!A2:A250.

Are you certain there are values in degrees!B2:B250? If so, are you certain there's some instance in which chkseconds2 <= chkseconds1 And chkseconds1 < chkseconds3?

For the heck of it, right before the If . . . If construct in which you set Result, add this statement.

Please Login or Register  to view this content.

If nothing appears in the Immediate window, then there are no instances of chkseconds1 falling between chkseconds2 and chkseconds3. On the other hand, if there are lines produced in the Immediate windows, does the LAST ONE show something between the square brackets? Note that the logic you're using iterates through the entire range degrees!A2:A250, and it only returns the value from degrees!B2:B250 corresponding to the LAST ROW in which chkseconds1 falls between chkseconds2 and chkseconds3. If all rows from 2 to 249 contain something in column B, but B250 is blank and A250 produces chkseconds2 and chkseconds3 which bracket chkseconds1, "" would be the expected (though apparently not intended) return value.

I updated the post with the data...values do exist but it still fails the

Please Login or Register  to view this content.

Just saw the problem: you're not resetting check2 or check3 to 0 after the 3rd and 4th For loops. Thus, after processing degrees!C2 and degrees!D2, count2 and count3 are both 3, so when you process degrees!C3 and degrees!D3, count2 and count3 would be 4, 5 and 6 in the 3 If blocks, for the next row 7, 8 and 9, etc.

Perhaps eliminate the 1st, 3rd and 4th For loops and use

Please Login or Register  to view this content.