nav2567
asked on
Compare columns in Excel document.
Hello Experts,
In the attached, I want to compare column E against column A.
Put "Match" in column F next to any items in column E that appear in column A.
Please advise a formula to do this.
Many thanks...
test-compare.xlsx
In the attached, I want to compare column E against column A.
Put "Match" in column F next to any items in column E that appear in column A.
Please advise a formula to do this.
Many thanks...
test-compare.xlsx
ASKER
It does not work. The formula is not putting MATCH next to JFK261FB.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See attached.
Does that work for you?
Alan.
EE-29164640-test-compare-Version1.xlsx