pennynikkel
New Member
- Joined
- Sep 3, 2003
- Messages
- 41
Is there a way to enter in a formula that will look at one cell and then if it is true, will give the value of another cell.
B2 = Day, 3 = Tuesdays, B4 = Date, Sheet 1 B31 = Date to Match, then I want the result in another cell, Sheet 1 B29.
Trouble is that putting Sheet1B29 in "" marks, just gives me that text, and I want the date that is in that cell.
For example, if=IF(AND(B$2=3,B$4='Sheet 1'!$B$31),"???","")
B2 = Day, 3 = Tuesdays, B4 = Date, Sheet 1 B31 = Date to Match, then I want the result in another cell, Sheet 1 B29.
Trouble is that putting Sheet1B29 in "" marks, just gives me that text, and I want the date that is in that cell.
For example, if=IF(AND(B$2=3,B$4='Sheet 1'!$B$31),"???","")