I am looking to pull the name of a customer from the tab “Contact_Data” based on a partial match to the data in column C of the tab “Chart_Graph”. I will be using this later to produce reports that show the last time a specific customer was contacted, but this is the key piece to getting to that point. Right now I need to focus on solving this equation first.

I’m trying to apply conditional formatting in Google Sheets based on data from two sheets. In Sheet1, I have a list of dates (Column B) and apartment names (Columns C onwards). In Sheet2, I have apartment names, arrival dates, departure dates, and some extra info.

If I do this formula, it can find the value I want: