pls stay in the ORIGINAL thread

David,

As Don responded, you should stay within your original thread

For your easy reference, I've put together a working sample at:
http://cjoint.com/?lpcy4u848V
DavidB_newusers.xls

The sample contains the revised suggestion to your original posting to use a
helper sheet (Y) to group together the discontiguous source range (in X)
into a continuous range. The formula in H8 (in X) then points to the
continuous range in Y for the appropriate evaluations. Full construct
details are provided in the sample file.

Take a look at the sample, and test out the returns in H8 using various sets
of inputs in the 11 source cells.

P/s: I don't know of any other way to get it up here.