...one more thing.

sometimes the value I want to look up is not BR9, but B9A, for
example.

Is there a more elegant way than two look these two possibilities up by
adding another sumproduct formula such as:

sumproduct(..."BR9...")+sumproduct(..."B9...")?

Thanks for your help!!
Titus


--
titushanke
------------------------------------------------------------------------
titushanke's Profile: http://www.excelforum.com/member.php...o&userid=19997
View this thread: http://www.excelforum.com/showthread...hreadid=519286