using VLOOKUP with Dates and Text
I have two sheets, one which keeps track of dates and reminder dates which is maintained by team and looks like this:
and another sheet which drives a form where people pick dates (a copy of the dates in Long Date above).
The "target Appointment Date" is a drop-down value field i.e. TEXT.
In the field "reminder 1" i would like to do a lookup to the dates field above. I would like to lookup the drop-down value in "Targeted Appointment Date" and bring back the "Reminder 1" date (which is a date field on both sheets).
I know the problem is that the field i am trying to match is a text field, while the table has all date fields. How can i fix this without having the change the table to text.
Help Article Resources
Check out the Formula Handbook template!