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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!