Hi,

I am doing a vertical seach in a matrix.
Let's say:
1 10
2 20
3 30
4 40

If I enter =Vlookup(2.5;matrix;2)
I obtain 20.

However, I would like to have the next value, 30 !

I have seach a lot and I have tried formulas like "Cells" but nothing worked.

How can i do that?

Thank you very much,

Alex