Hi,

Try with closing the MAX function

=VLOOKUP(A3968,'Future Phase in values'!A2:P3429,MAX('Future Phase
invalues'!I2:P2),FALSE)

Wkr,

JP

"Iriemon" wrote in message
...
I'm trying to set up a formula to find the MAX value in a range using
VLOOKUP. All I get is a "#value" error with the formula below. I tried to
substitute "MAX('Future Phase in values'!I2:P2" for the column number but
it
doesn't like it.

Any help will be greatly appreciated. I know there must be a simpler way.
I
can always put in a "helper" column that will find the Max value and then
have the VLOOKUP return that column but I'm trying to avoid adding any
additional columns to my "Future Phase in values" worksheet. Can it be
done
using VLOOKUP or do I need to use another function?

Thanks

=VLOOKUP(A3968,'Future Phase in values'!A2:P3429,MAX('Future Phase in
values'!I2:P2,FALSE))