Hope someone can help me with this, since I`ve tried for a while now, but can not get it to do what it is supposed to. I am helpless when it comes to macros, and was hoping that it was possible to do without. Here goes.....

I have a cell F16 that changes value between 0,1-0,2-0,3-0,4. And then I have a cell G16 that changes in values.

What I was hoping is possible, is for some kind of function that use the F16 valuse to search in different columns (ifF16=0,1then search in column h) (0,2=column L, 0,3 = column P, 0,4 = column T). When searching these columns I would like to come up with the numbers that are equal to,closest to but smaller, and closest to and bigger in the cells Q16-17-18.

Is there anyone that understands what I am trying to do here, and can help me??

I would really appreciate it.

T.