Which excel formula should I use for this example?

I have a range of block addresses for each TRS and need to find the correct TRS to go with an individual address.  For example: Block Street TRS   Lowblocknumber Highblocknumber Street TRS...