Steve,
This revision should do it. In M14 (normal ENTER will do):
=IF(OR(E10="",B22="",E16=""),"",INDEX(INDIRECT("'" &E10&"-"&B22&"'!E61:H61"),,MATCH(E16,{"A";"B";"C";"D"},0) ))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"S Willingham" wrote:
Thanks Max

E61 to H61 contain the info needed. That is, they contain the total of the
quote for the color group A-D

I entered the formula and it returned a #N/A