Index, Match with a Contains.

Michael Foster
Michael Foster ✭✭✭✭
edited 11/24/22 in Formulas and Functions


I normally index match to return a value from a table but this only works for the match section if it is a 1 for 1 scenario. The scenario i currently have is the reference table which i'm indexing from for the field i am using as a match has additional information (See Table 2). How do i collect the information from Table 2 if it has additional information. I have tried to introduce a contains in but i get an error.

Thanks in advance for your help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!