Index Match for Contact List
I'm using an IFERROR
formula with INDEX MATCH
to pull names from two separate sheets, both of which use a contact list column type. However, for some entries, I get a contact list icon (with the email attached), while for others, I only see the individual’s name as plain text. I can't figure out why there's an inconsistency between the two formats. Could anyone help me understand why this happens?
=IFERROR(IFERROR(INDEX({LRT.Requestor(s) Name}, MATCH([MLL ID]@row, {LRT.MLL ID}, 0)), INDEX({CLRT.RN.Helper}, MATCH([MLL ID]@row, {CLRT.MLL ID}, 0))), "")
Reg Product Manager is on the sheet with the above formula and is a contact list:
LRT.Requestor(s)Name I believe is where the free text is coming from and the row it would be matching to shows the contact icon:
CLRT.RN.Helper is another contact list column and the people from here are coming through as contacts not just text:
This last screenshot I have a very similar column being used next to the one in question and all these seem to be coming through correctly, but you can see the VN person is messed up!
For reference here is that other formula for the working column:
=IFERROR(IFERROR(INDEX({LRT.Assigned To}, MATCH([MLL ID]@row, {LRT.MLL ID}, 0)), INDEX({CLRT.AT.Helper}, MATCH([MLL ID]@row, {CLRT.MLL ID}, 0))), "")
Any assistance is appreciated, thank you!
Best Answer
-
Fresh eyes this morning found the solution… removed the multiple select haha
Answers
-
Fresh eyes this morning found the solution… removed the multiple select haha
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!