May 15 2019 12:27 PM
May 15 2019 12:27 PM
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.
May 15 2019 01:07 PM
The Excel function for your requirements is MATCH(). It works nicely for exactly what you are doing. Of course, you will build a formula with a couple of MATCH() functions and an IF.
May 15 2019 01:14 PM
@Deleted , for the first, if you'd like to have the flag against each value in C, when like
=IF(COUNTIFS(I:I,C2,O:O,C2),"have","")
or you's like to generate the list of such values? Same question about second case