I tried both methods and neither have work successfully yet. However, the one
below seems the simplest. Can you walk me through how you created the names
and lists and how the indirect feature works? I think my biggest trouble is
figuring out what to do with both the "Slope" names...and the relationship
between the two indirect's.
Thanks so much for your help.
"Herbert Seidenberg" wrote:
Excel 2007
Scariest (and only) formula used:
=INDIRECT(Zone) INDIRECT(Slope)
http://www.mediafire.com/file/gdj2yo...12_23_09a.xlsx
.