Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Vlookup and MAX functions
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)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
$ for VLOOKUP functions | Excel Worksheet Functions | |||
if and vlookup functions | Excel Worksheet Functions | |||
VLookup Functions | Excel Worksheet Functions | |||
How do I add vlookup functions together | Excel Discussion (Misc queries) | |||
Using VLOOKUP, IF and RIGHT functions together | Excel Worksheet Functions |