I am looking for a formula that produces the following please
If range of values in column B also appear within range of values in column A, column C = YES or NO
I know this is probably a very basic query and that the answer is out there i just cant work out how to word my question! Hopefully this makes sense.
Please try below formula:
Sample file is also attached for your reference.
Hi, assuming your table starts in cell A1, write this formula in Cell C2 and copy down: