I noticed that the MATCH fomula has a limitation of the length of the text. I.e, I am matching the names between two sheets. I have some long names -Mohammad Ali Hussaini, Mohammad Muttaqi. When i plug in the fomula, it always return the first one.
How can i fix this?
Help Article Resources
Check out the Formula Handbook template!