Forum Discussion
Posting a date based on an event
Hello Forum, Does any one know of a way thru a formula to post a date into a cell based on an event happening on other sheet. I have a sheet that makes a random selection of people from my ...
Try this:
1: Set Up Your Sheets
- Sheet 1: This sheet contains your roster and the random selection of people.
- Sheet 2: This sheet will display the selection date based on the event happening on Sheet 1.
2: Create a Trigger Event
You need to create a trigger event on Sheet 1 that will update the date on Sheet 2. You can use the IF and VLOOKUP functions to achieve this.
3: Write the Formula
On Sheet 2, in the cell where you want to display the selection date, use the following formula:
excel
=IF(VLOOKUP(A2,Sheet1!A:A,1,FALSE)<> "", TODAY(), "")
4: Copy the Formula
Copy the formula to other cells in the same column on Sheet 2 where you want to display the selection date.
Based on the possible solution you provided and my reply to you with all the info on what is going on, would you please help me formulate the solution.