Hello,
I am looking for a formula or macro that will help me do the following:

Let's say I have data as:

542 A 2.5
544 B 2.8
5423 C 1.9
5421 D 1.4
54233 E 1.9

In another data set I have I am running an INDEX/MATCH so I can get the 3rd
row value.

So somewhere else I may have

542 J 2.5
544 Z 2.8
5423 Y 1.9
54214 R ?
542332 S ?

Given this, the last 2 would not find a match, however, what I would like
them to do is to roll up and find the nearest match so that, 54214 would
recognize that it matches the 5421 in the other data set before it reaches
the 4 and would enter 1.4 and the second one would find the match at 54233
before the 2 and would enter 1.9