I have Sheet 1 and Sheet 2. They both contain the same list of names. Names are shown in 2 columns, Last name and First Name.
Sheet 1 also has a column ("A") for separate input. When an "M" is put in Sheet 1 cell A2, it should get the name in B2 & C2, look for a match
in Sheet 2, and when found place a "1" in Sheet 2 cell C2. It should continue until all rows have been cfhecked. I've been at it for hours but no luck.
Sheet 1 also has a column ("A") for separate input. When an "M" is put in Sheet 1 cell A2, it should get the name in B2 & C2, look for a match
in Sheet 2, and when found place a "1" in Sheet 2 cell C2. It should continue until all rows have been cfhecked. I've been at it for hours but no luck.
Last edited: