|
Posted to microsoft.public.excel.programming
|
|
|
Referencing a Origin Cell from Data Validation
I added ""'s
=CELL("address", INDEX("I6:I333", MATCH("B16, I6":I333, 0) ) )
Thanks again
"shg" wrote:
Or =CELL("address", INDEX(I6:I333, MATCH(B16, I6:I333, 0) ) )
--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24666
|