Forum Discussion

Copper Contributor

May 10, 2022

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...

excel

Formulas and Functions

HansVogelaar
May 10, 2022
marinamos

=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.

marinamos

Copper Contributor

May 10, 2022

HansVogelaar Here you go!

https://docs.google.com/spreadsheets/d/1H8rV29DZKWEWR9NXHNrzzwUI_c9pjxyA/edit?usp=sharing&ouid=112757543183169338601&rtpof=true&sd=true

thanks a lot

JoeUser2004

Bronze Contributor

May 10, 2022

marinamos posted: https://docs.google.com/spreadsheets/....

Google Sheets is not an Excel. I don't believe an Excel file uploaded to Google Sheets is the original Excel file.

If you "must" use Google for file-sharing, upload to drive.google.com, not docs.google.com.

I prefer an "unaware" file-sharing website like box.net/files or dropbox.com. Then I'm confident that the file is not changed by "smart" software.

marinamos
Copper Contributor
May 10, 2022
its a drive link, it does say docs.google but when getting access you can download the file! I tried the link with other people and it should work correctly! please let me know if you get access to it? thanks a lot
- HansVogelaar
  MVP
  May 10, 2022
  marinamos
  
  I still get Access Denied.
  - marinamos
    Copper Contributor
    May 10, 2022
    HansVogelaar sorry for that, I gave full access now, maybe now it works? 😕
    
    https://docs.google.com/spreadsheets/d/1H8rV29DZKWEWR9NXHNrzzwUI_c9pjxyA/edit?usp=sharing&ouid=112757543183169338601&rtpof=true&sd=true
    
    Thanks a lot