xnickeddlemanx✭

Comments

  • L@123
    in帮助with INDEX MATCH with duplicate unique identifiers Comment byxnickeddlemanx 01/20/20
  • Hi Genevieve, When I remove the IFERROR portion, I am still getting #No Match answer. You are correct, the Range 7 is Cohort# and Range 8 is SSO. Both are numbers for the SSO columns in both sheets. Now, one thing that i forgot to mention is that the Cohort # column is a formula, pulling text from another column. I'm using…
    in帮助with INDEX MATCH with duplicate unique identifiers Comment byxnickeddlemanx 01/20/20
  • Looks like they work independently. Formula 1: =IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Training Completions Range 1}, 0) > 0, "YES", "NO") Formula 2: =IF(MATCH(([Employee ID]1+ [Current Position]1 + [Training Name]1), {Training Completions (2) Range 1}, 0) > 0, "YES", "NO")…
    inMatch Statement with Multiple Sheets Comment byxnickeddlemanx 11/13/19
  • Same issue - throwing an N/A. I adjusted the formulas: =IFERROR(IF(OR(MATCH([Employee ID]1+ [Current Position]1 + [Training Name]1, {Completions Range 1}, 0) > 0, MATCH([Employee ID]1+ [Current Position]1 + [Training Name]1, {Completions (2) Range 1}, 0) > 0), "YES", "NO"), "NO") Thoughts?
    inMatch Statement with Multiple Sheets Comment byxnickeddlemanx 11/08/19
  • Thanks for the help - it looks like it's reading as an error. If i change the "NO" at the end of the IFERROR to N/A, it's changing all of the orginal "YES" answer to "N/A" as if there's an error. Below is the formula =IFERROR(IF(OR(MATCH([Employee ID]1+ [Current Position]2 + [Training Name]2, {Completions Range 1}, 0) > 0,…
    inMatch Statement with Multiple Sheets Comment byxnickeddlemanx 11/07/19
Avatar