Forum Discussion
Excel Help with what may be a lookup
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....
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