Formula to look at a table and find a word and apply it to another tab

[bigtwenty]

Hello everyone!

I have a spreadsheet that has some clients and meeting frequencies on them. For example, I have a calendar of First Monday, Second Monday etc in the first column. Then in the
rows up top, I have the months. On another tab, I have a single column that syas "Meeting Recurrence". What I would like to happen, is create a formula in the "Meeting Recurrence" column on the clients tab that would look at that table on the calendar tab and if the text in there had the client's name, then put in the recurrence schedule (1st monday, second monday or whatever)

I have attached the XLSX.

[VLB]

Yearly Client Meeting Schedules - 2015 EXCEL FORUM.xlsx

Hi bigtwenty,

recurrence makes sense as long as there is such.. I mean, as far as I could see, there is no strong particular pattern for any of the customers.. I managed however, to get something similar in the columns for the months, have a look