I have two pages, each with 2 columns of addresses per row.
I am trying to search for duplicate address values across columns on each sheet. I need to return "Y" in a third column on page 2 if one or both columns on page 1 contain a value from page 2's respective row. The value in A4 on page 1 might be in B100 on page 2, and vice versa.
Can I do this without a VBA?
Thank you!
I am trying to search for duplicate address values across columns on each sheet. I need to return "Y" in a third column on page 2 if one or both columns on page 1 contain a value from page 2's respective row. The value in A4 on page 1 might be in B100 on page 2, and vice versa.
Can I do this without a VBA?
Thank you!