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.
HansVogelaar Here you go!
https://docs.google.com/spreadsheets/d/1H8rV29DZKWEWR9NXHNrzzwUI_c9pjxyA/edit?usp=sharing&ouid=112757543183169338601&rtpof=true&sd=true
thanks a lot
Please share the workbook - I currently get "Access Denied".