Hi,
I have two columns, on the same sheet, and I wnat to look at the values in one column and see if a given value is in another; and then in a third column show that it is in the first column, and the cell that it is in. If this is not possible, it can just show True or False.

For example;
Thank you

Hi
do you really need the cell reference if true? What would you do with it?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Well it would be nice, if I had a lage table and other collumns like dates that I wanted to compare, but that is okay how would you do this with True. I tryed formulas and Vlookups and I am doing something wrong I canot get it. Do you have any idea of what I can do?
Thank you