Excel Help with what may be a lookup

Deleted
Not applicable

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. Screen Shot 2019-05-15 at 3.18.33 PM.png

2 Replies

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.

 

@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