Unique list of values w/ VLOOKUP or INDEX/MATCH not working
I am trying to use the aforementioned functions to crate a list of unique values by referencing a separate sheet. The source sheet contains a column of date values and a column of checkboxes which indicate unique dates. using either functions indicates #NO MATCHES which is incorrect. Please let me know how to make this work correctly.
Help Article Resources
Check out the Formula Handbook template!