darblooz wrote:
Thanks,

I've never heard of that function before.

I've searched a bit about this function, wow looks kinda complicate to
me but i guess i'm on my way to resolve my problem ;) .


--
darblooz

If you wanted to use a series of nested IF statements, there is a limit
of 7 that you can use in one formula, so if you have more than 7 values
you have to use something else. VLOOKUP is one such alternative - it
enables you to search through a table looking for a match, which can
either be an exact match (final parameter set to FALSE or 0) or a match
on the highest value which is less than the value you are searching
for. In this latter case the table has to be sorted. The third
parameter enables you to select which column of the table the data
should be returned from if you find a match - in your case it will be
2. The second parameter is the table range - if you set up a little
table of your values say in cells L1 to M10, then this is your range.
The table could be on another sheet.

Post back if you need any further help.

Pete