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....
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.