I've got these two tables on two different worksheets.
A1: ID B1: Name C1: Locality D1: ID_2 E1: Status A1: ID B1: Name C1: Locality D1: Status
Basically I need to match the two tables via "Name". If the names are similar I want to fill in "ID_2" with "ID" in WS2. I also want to display "Y" in status if there's a match.
Is there a formula that does this? Or do I have to use VBA.
Office Version: 2003