Identify Range based on set of values

[ankurm84]

Hi,

I have set of values in column A, for e.g.

10,20,30,40,50,60,70,80,90 and 100.

Now in column B I have below values

33,50,60,90

How to identify, range of values in column A based on values in column B.

It should return following values : 30,40,50,60,70,80 and 90(assuming we are taking nearest value of 33, which is 30 in this case).

Thanks in advance.

Regards,
Ankur

 

[Col Delane]

You need to explain your criterion for matching the values in B with those in A. (How do you get 7 return values - especially 40, 70, 80 - from column A for just 4 values in column B?)