View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Milind Keer[_2_] Milind Keer[_2_] is offline
external usenet poster
 
Posts: 46
Default Formulas Reference

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.