Hello, If someone could help me out, I would really appreciate it. I can't put a formula together. Background: I had a report with contact emails, account IDs and account names; however those emails were not matched to the correct account names. I matched the emails with correct account names and also matched IDs to the account names as well.
Columns:
A: account ID
B: account name
C: corrected account name
D: account ID matched to the corrected name.
I need to do some Q&A. I need a formula that would validate that the ID I copied for (C) is the same with A and B. I can validate this when B=C and in the same row, but not when it's not. I assume I need to use if, vlookup and match, but can't find anything like that online.
I think that is how I need to formulate it: display "y" or "n" if B=C and A=D??
Thank you in advance.
Columns:
A: account ID
B: account name
C: corrected account name
D: account ID matched to the corrected name.
I need to do some Q&A. I need a formula that would validate that the ID I copied for (C) is the same with A and B. I can validate this when B=C and in the same row, but not when it's not. I assume I need to use if, vlookup and match, but can't find anything like that online.
I think that is how I need to formulate it: display "y" or "n" if B=C and A=D??
Thank you in advance.