Hi Domenic,
Thank you very much for assisting with your Formula below, I just tweaked the
nested LEFT function to LEFT(B$1,1) rather than LEFT(B$1,2); otherwise
perfect.
Thank you, once again.
Sam
------------------------------------------------------------------------
=IF(ISNUMBER(MATCH(LEFT(B$1,2)+0,Sheet1!$B19:$H19, 0)),IF(MATCH(LEFT(B$1,2
)+0,Sheet1!$B19:$H19,0)<7,IF(INDEX(Sheet1!$B19:$H1 9,MATCH(LEFT(B$1,2)+0,S
heet1!$B19:$H19,0)+1)=(LEFT(B$1,2)+1),(LEFT(B$1,2) +0)&"-"&(LEFT(B$1,2)+1)
,""),""),"")
--
Message posted via
http://www.officekb.com