Glad we got it resolved finally <g

=IF(OR(E10="",B22="",E16=""),"", ..
This front part of it simply checks that all 3 input cells contain "inputs"
(viz. something) before evaluating any further

... INDEX(INDIRECT("'"&E10&"-"&B22&"'!E61:H61"),, ...)
The INDIRECT will resolve the concat string composed from the inputs in E10
& B22 to return the correct sheetname for the indexed range. This is the main
flexibility provided.

.... INDEX(... ,,MATCH(E16,{"A";"B";"C";"D"},0)))
The matching of the input in E16 against the constant array: {"A";"B";"C";"D"}
returns the correct col number for the INDEX to return from the particular
sheet's indexed range "E61:H61"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"S Willingham" wrote:
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!