I have a very large database that contains transations and I want to compare bin numbers against a table to determine where the transaction resides from.
table one contains the order,
example bin 444445
against table w that contains over 10k varations of bins, High and low, and its corresponding country.
so you would compare 444445 against two cells to see if it fits in the range and then spit out the country for that line.
because of the number of records, it would need to proceed to next record once it find the matching range.