Index and Match where one of the lookups needs to be nearest to

Originally Posted by ConneXionLost

Do you mean the rate to the nearest and the GTY to the nearest? Or just the GTY to the nearest?

If just the GTY, then build another lookup table and sort it by GTY.

Rate and GTY. Eventually there will be many many lookups within 10's of thousands of rows of data. I am trying to wrap my head around this type of match