=IF(INDIRECT(A1)="Milind", "Exist", "Does not Exist")


--
__________________________________
HTH

Bob

"Milind Keer" wrote in message
...
Hi

=IF ([Data] UK!B7 = "Milind", "Exist", "Does not Exist")

here can I give reference to '[Data] UK!B7'??

e.g

A1 = [Data] UK!B7
Can I say

=IF (A1 = "Milind", "Exist", "Does not Exist")

basically i want to pull '[Data] UK!B7' from some othr cell... as dis is
dynamic in my case... it keeps changing all the time and evry time i dont
want to modify my formula... i dont even want to do find-replace.

plz advise.