So I have a table which contains companies that a group of people will visit on given dates. I'm trying to make a formula that will have index for the companies and match it for the given date. When dragging down the formula or double clicking it, it should show all companies that will visit on the given date without giving duplicate values and skip cells that don't have a date.
The formula I am using which is giving me duplicates is:
=INDEX(Table1[Company],MATCH(G2,Table1[Date of visit],0))