Forum Discussion
Solved
Index Match #NA error
Hi! Hope you can help me... I use office excel 2019 (so use ctrl+shift+enter to enter my index match formula). I have 3 array sheets as reference and 25 product sheets with the exact sam...
=LEFT(T5,9) returns "SK386IVO ", with a space at the end. The POs sheet has "SK386IVO" without a space.
If you change the formula to =TRIM(LEFT(T5,9)) to remove the trailing space, it'll work.
Please make a sample workbook (without sensitive data) available through OneDrive, Google Drive, Dropbox or similar.