Wildcard Workaround

Stacy Calhoun

Hello! I'm trying to achieve a formula that would usually use wildcards. So in Sheet 1, I have three columns, Meeting, Date, and Time. In the first row of the Meeting column, I have the following data: Topic 1 - Tuesday, October 17 @ 10am - 10:30am. The Date and Time columns are blank for now. In Sheet 2, I have three columns, Topic, Date, and Time. In the first row I have Topic 1 under Topic, Tuesday, October 17 under Date, and 10am - 10:30am under Time. Now here is what I'm trying to do:

On Sheet 1, I want to build a formula on the first row under the Date column that finds Topic 1 from the meeting column in Sheet 1 in the Topic column of Sheet 2 and pulls the Date field over from Sheet 2 into Sheet 1. Again, it's not an exact match of data since the meeting column in Sheet 1 says "Topic 1 - Tuesday, October 17 @ 10am - 10:30am" and the Topic column in Sheet 2 says "Topic 1" Can you please help???

Amit Wadhwani

Hi @Stacy Calhoun

I am assuming that the topic in both the sheets is the same. You should try splitting out the topic in sheet 1 in a new column using LEFT function, with - as delimiter. You can then use this new column to do an INDEX MATCH from sheet 2.