Alexandre, try this out:

=VLOOKUP(ROUNDUP(2.5,0),matrix,2)

The ROUNDUP() function rounds the number up to basically 3 and thus matches
the 30 you are looking for.

Cheers,
Socratis

"Alexandre Campeau" wrote:

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