You can try below to make it dynamic.
=IFERROR(LOOKUP(2,1/((SUBSTITUTE($A$2:$A$8,LEFT(F2,FIND("^",SUBSTITUTE(F2,".","^",3))),"")+0<=MID($F2,FIND("^",SUBSTITUTE(F2,".","^",3))+1,10)+0)*(SUBSTITUTE($B$2:$B$8,LEFT(F2,FIND("^",SUBSTITUTE(F2,".","^",3))),"")+0>=MID($F2,FIND("^",SUBSTITUTE(F2,".","^",3))+1,10)+0)),$C$2:$C$8),"not found")

However, your last row, has two different value between 2nd "." and last "." in Column A & B.
248 vs 255. Formula won't be able to accommodate for that.