Thanks! That's a good start - I should have been more specific.

What I'm trying to do is return 1 of 2 possible values in a table for each named range, based on an additional drop-down.

For example, if drop-down 1 = John, and drop-down 2 = Tim, AND drop-down 5 = Utilization.... Show me the combined utilization for John + Tim for 2002. The next cell would show the same data for 2003, etc.

Any thoughts?