=IF(C7="policy",Policy!H11,IF(C7="calls",calls!H11 ,"undefined output"))
--
David Biddulph

"Atishoo" wrote in message
...
I want to return the contents of a cell on a seperate worksheet refered to
by
name in another cell:

so if cell c7 ="policy"

and I want cell mainpage!D10 to return the value in Policy!H11

or if cell c7 ="calls"

then I want cell mainpage!D10 to return the value in calls!H11

any ideas?