Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

  • ✭✭✭✭

    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

  • ✭✭✭✭

    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!

Trending in Formulas and Functions