Compare columns in Excel document.

nav2567
nav2567 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AlanConsultant

Commented:
Hi,

See attached.

Does that work for you?

Alan.
EE-29164640-test-compare-Version1.xlsx

Author

Commented:
It does not work.  The formula is not putting MATCH next to JFK261FB.
Consultant
Commented:
It is at my end:

EE-29164640-test-compare-Version1.png
What are you seeing?


Alan.
Rob HensonFinance Analyst
Commented:
Another option using MATCH function, use below formula in F2 and copy down as required:

=IF(ISERROR(MATCH(E2,$A:$A,0)),"","MATCH")

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial