Original working formula:

=MAX(IF(GNC70901!$B$2:$B$20000="N",IF(ISNUMBER(MATCH(LEFT(GNC70901!$C$2:$C$20000,2),

**$B$49:$B$64**&"",0)),GNC70901!$H$2:$H$20000)))

Instead of a range (

**highlighted**) I only want it to look at a specific cell but when I made that change (

**below formula**) it stopped working...what am I not doing right? What am I missing in the below formula? It is not calculating....returns the value of "0".

=MAX(IF(GNC70901!$B$2:$B$20000="N",IF(ISNUMBER(MATCH(LEFT(GNC70901!$C$2:$C$20000,2),

**B49**&"",0)),GNC70901!$H$2:$H$20000)))

Thank you!

Regards,

rthakur