Reply to thread

Message: [QUOTE="Excel Curious, post: 3835624"] Ok... =VLOOKUP(A3968,'Future Phase in values'!A2:P3429,8+MATCH(MAX(INDIRECT("'Future Phase in values'!I"&MATCH(A3968,'Future Phase in values'!A2:A3429,0)+1&":P"&MATCH(A3968,'Future Phase in values'!A2:A3429,0)+1)),INDIRECT("'Future Phase in values'!I"&MATCH(A3968,'Future Phase in values'!A2:A3429,0)+1&":P"&MATCH(A3968,'Future Phase in values'!A2:A3429,0)+1),0),FALSE) There may be a more "streamline" way of doing this, but this is what I could come up with. [/QUOTE]