No, it does not only look in E2. Remember, it is not matching on column E. It is matching on column D, and checking the value in column E for whatever row that match occurs in.Joe what happens if i change it to "Tuesday" and want to pick up that also. I tried that but not working. I tried to put formula in 3 columns over and change it to Tuesday bit returns nothing.
I think because its only looking in E2? rather then going down the whole column?
I am not sure I follow what you are talking about. I think it would be helpful to see what your data looks like (showing all the pertinent columns, and column and row headers).I figured out the issue i am having. If i change it to $D$3 it works because Tuesday in E next to $D$3. i really need $D$2 as like D:D need to look through column to match the same in D11 and look in E for the word like Tuesday. I tried D:D but nothing.