Forum Discussion
Solved
Index match formula does not work as it should
Hi all, I'm working on a file, existing from a couple imported files. I've been trying to obtain data from one tab to another by using the index/match formula. This works on 303/309 of the row...
Thomas1330 You have trailing spaces in some of the entries in "Ruimte". For instance, you try to match "A1.010" with "A1.010 ". That returns #NA! Just delete the space at the end and it works.
Thomas1330 You have trailing spaces in some of the entries in "Ruimte". For instance, you try to match "A1.010" with "A1.010 ". That returns #NA! Just delete the space at the end and it works.
Thank you Riny, it worked out!
Thomas1330 Graag gedaan!