• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 66
  • Last Modified:

Need help with Excel formula comparing columns

Why do I keep receiving this error in my Excel formula? I want to match column F with G.
Screenshot attached.

 =IF(F2=G2,"Match","")
Capture.PNG
0
maximus1974
Asked:
maximus1974
2 Solutions
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Replace comma with semicolon (;) in your formula and see if that works for you.
0
 
maximus1974Author Commented:
Same error using semicolon. Error attached.
Capture.PNG
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
That's strange.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
NorieVBA ExpertCommented:
maximus1974

Can you attach a sample workbook with some sample data?
0
 
maximus1974Author Commented:
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Can you see the working formula in column H in the attached?
inventory-valuation-by-location-pe-m.xls
0
 
AlanConsultantCommented:
Hi Maximus,

It seems to work fine for me - see attached with the formula in.

I don't get any matches though.

Alan.
EE-29087572-inventory-valuation-by-l.xls
0
 
Christopher RourkeProduct Manager @ Experts ExchangeCommented:
Hello Maximus,

The formula works as expected for me as well. The only way I was able to reproduce the error you are experiencing was to leave out the commas. Would you mind testing something, plug another formula in that uses commas as a separator and see if the error triggers for it as well. For example:

=SUM(J2,J4,J6)

If you receive the same error for that then the information in this link from Microsoft support may help you:
https://support.microsoft.com/en-us/help/2853427/formula-errors-in-excel-when-list-separater-is-not-set-correctly
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now