How do you reference a defined range (dynamic) on another sheet?
This doesn't work and several other variations I have tried. . . [
I]=LOOKUP(Sheetname!A1, RangeName) [/i]


--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=523313