Here is what I would like for my spreadsheet to do, but I am not sure if it is possible. I want it to take the values in Column C and see if the same value is displayed in BOTH Column I and Column O. If the value is in displayed in all 3, meaning the value in C was found in BOTH I and O, I want it to return something like "Have." I also want it to tell me the values that are the same in both I and O, but are not present in C. Is this possible? I have done lots of research, but been unable to find a way.