Index, Match with a Contains.
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
Check out the Formula Handbook template!