Index/Match Formula Referencing Contact Columns Providing Wrong Values

I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for sharing purposes.

Before I get too far into this formula, I am trying to start with a simple Index/Match but it is returning the wrong value. Help!

=INDEX({DAM Group Management | DAM Partners}, MATCH([Requestor Email]@row, {DAM Group Management | DAM Partners}))

Answers

  • Shimanta Roy
    Shimanta Roy ✭✭✭✭

    I guess, your references are not correct. In your given formula, you have used {DAM Group Management | DAM Partners} in both the Index range and Match range, which seems incorrect. Could you share the more elaborately which columns are you referring for which purpose?

    Senior Business Intelligence Analyst
    Augmedix Bangladesh
    (A Commure Company)
    shimanta@augmedix.com

  • Chelsea.McCulley
    Chelsea.McCulley ✭✭✭✭

    It is a sheet with a single contact column. I am trying to have the formula in a different sheet look for a value in that column and if it finds it, return it. My ultimate goal is to reference a contact in sheet a, look through the contact list in sheet b, and if the contact is not there then alert me. If there is a better way to do this, I am all ears.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!