Find a cell adress between a list of sorted values

Good night,

I have a doubt and I've been wondering how to do this for quite some time (I've managed to do it in a hard way, but I suppose it is possible pretty easily).

The thing is:

I have a row with SORTED data lets say: 1,2,3,4,5,6,7...,100 each number in a different cell. Now I want to search for a value present in another cell, lets say 2.5. Since it isn't an exact match it should return me the number 3 (function match?) and then I want to search a different number, lets say 33.3 and do the average between the values in the first row between 3 and 33.

Is that possible?

Thanks
Joao

Change the title according to the forumrules.

the yellow cells are helpcells.

the green cells are thw result

see the attached file

Thanks for the reply.

Glad I could help.

you can add rep(utationpoints) to the one who helped you, by clicking on the star on the left side.

Please also add the threat solved