tzip123 wrote...
....
and yes i know the numbers are overlapping - that is WHY I REDID THE
EXAMPLE - it does not often over lap but has the potential to overlap
so that is why I gave a new example

OK, so you realize that if ranges could overlap, it becomes possible
that some lower ranges could be skipped because higher ranges exhaust
the possible values. Even so, if your tables spans multiple rows in 3
adjacent columns, say A1:C15, you could use INDEX and MATCH as follows.

=INDEX($C$1:$C$10,MATCH(1,(A12=$A$1:$A$10)*(A12<= $B$1:$B$10),0))