Hi,
Is it possible to compare a column of names in one worksheet (A) with a column of names in another worksheet (B) and if it exists in both, insert text into a column on the sheet (B)? I currently have one sheet named Payments with only names of people who made payments stored in column A:2 down and another sheet named Group of many people A:5 and down. I would like for the word “Paid” to be placed in Group column D of a groupmember whose name exists in payments. Is it possible to do this? I would sincerely appreciate any help.
Thank you,
Sisu