ah, see if helps when you give us all the details.,

Use

=INDIRECT("Sheet2!B"&ROW(A1))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dileep Chandran" wrote in message
oups.com...

Thats fine. But its not working if we are refering to another sheet.

Say if the forumla is =Indirect(Sheet2!B1)=False

Any idea?

-Dileep