searching for column data
Posted on 2013-11-22
I have 2 lists I need to search data in. All is alpha-numeric.
I need to take one value and see if it exists in the other list.
For example, data is in both columns B and C. I need to take B2 and then search C2:C286 and in D2 show either yes/no, true/false - whatever is possible. Then take B3 and search C2:C286 and show a result in D3 and repeat all the way down.
I can't seem to find a function that will do this. I've been looking around at lookup/vlookup/match and don't know if that can do what I need.
Running Excel 2010.