Get Value from a table

[NunoDelgado]

Hi

I'm trying to use PROCV to get a value betewen to values. Exemple:

Col1 Col2 Col3
0 20 BAD
21 40 Not So BAD
41 50 Almost
50 100 You did it


The idea is that when i put a value in a cell, for exemple 35, the result should be Not so BAD .

Is it possible to do this whit a PROCV function?

Tanks

[martindwilson]

you could just use
=LOOKUP(D1,{0,21,41,51},{"bad","not so bad","almost","you did it"})

[NunoDelgado]

hi

Tank you for you post. It soved my problem