Lookup value in colA whos row matches row of index value in colB
 

Thanks to everyone for your rapid responses. QED! -Gwen :)


--
Gwen Frishkoff
------------------------------------------------------------------------
Gwen Frishkoff's Profile: http://www.excelforum.com/member.php...o&userid=15907
View this thread: http://www.excelforum.com/showthread...hreadid=273889

Gwen,

Replace the formula in E50 in the system I posted with:

=MAX(IF(INDEX(B52:B59,MATCH(E49,C52:C59,0))=B52:B5 9,C52:C59))-E49

which must be confirmed with control+shift+enter instead of just with
enter.

Gwen Frishkoff Wrote:
Thanks to everyone for your rapid responses. QED! -Gwen :)


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=273889