Forum Discussion
Solved
If formulas
Hi, Any ideas for a formula that will identify if values in one column are present in another? E.g, if values in column a are also in column b then return a yes. Thanks, Hannah
The formula tells you whether a value in the first range also occurs in the second range.
So the formula only makes sense in the rows of the first range, below that it will always return FALSE.
For example:
In C1, enter the formula =ISNUMBER(MATCH(A2, B:B, 0))
This will return TRUE if the value of A1 occurs in column B, FALSE if not.
Fill down from C1.
Thanks for your response. Do you think this has worked? One column has more values than the other, and as soon as column a ends, it changes to false.
The formula tells you whether a value in the first range also occurs in the second range.
So the formula only makes sense in the rows of the first range, below that it will always return FALSE.