Excel formula to compare single value in one cell with multiple values in other cell
- by Raw
I have a value in Column A, which I want to compare with multiple values of corresponding cell in column B, and depending on that value, put the answer in column C.
For example, using the table below, it searching in column B for values which are less than or equal to 12 and put the answer in same order in column C.
Column A Column B Column C
12 0,12,13,14 Yes, Yes, No, No
101 101,102,103,104 Yes, No, No, No
How can I do this in Excel?