OK That is COOL. can you explain how it works. I might want to duplicate it
in another application.
Thanks again for all the help!
"Max" wrote:
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