Try this:

=VLOOKUP(MAX(I12,M12,O12),A$1:B$6,2)

I think this is what you require.

Hope this helps.

Pete

On Sep 23, 2:57*pm, Fred wrote:
I am trying to lookup values in a row within a table (*below). *This table is
For a 'range' which a returned value must fall into as follows:

A * * * * * * *B
2.99 * *0.00
3.00 * *2.00
4.99 * *2.00
5.00 * *4.00
8.99 * *4.00
9.00 * *6.00

For Example if a row has the values: I12 1.84 * M12 3.01 O12 2.98 *I need to
return the value of 2.00.

Will a lookup tabl eor if stmts work, Any thoughts?