janhoedt
asked on
Excel: compare two lists
Hi,
I have 2 columns which I need to compare in Excel (hotfixes of Windows).
I'd need to have column C to show if items in column B can be found in column A.
Please advise.
J.
compare.xlsx
I have 2 columns which I need to compare in Excel (hotfixes of Windows).
I'd need to have column C to show if items in column B can be found in column A.
Please advise.
J.
compare.xlsx
ASKER
Thanks, but I get "the formula you typed contains errors".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Pls try
=IF(ISERROR(MATCH(B1,A:A,0
Regards