Hi All.
I have attached an example.
I want to have my example to see if what text i have in C3 appears in D6:F6 and if it does then return what is in C6 as text.
So i have done the first example. If the text in C3 John appears in the list of employees in week one then return the contents of C6 (Test)
Hope this is clear.
Thanks in advance
Bookmarks