If range_lookup is Accurate or disregarded, the first column should be sorted alphabetically or numerically. If the main column is not sorted, the return price might be one thing You do not expect. Either sort the initial column, or use Bogus for an actual match. Whenever you convert your spreads