Forum Discussion
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 rows, but for 6 of them, for no apparent reason, it does not work out.
Yesterday I've been trying to solve it for over an hour with a Microsoft employee but we still could'nt find the problem.
Two different errors appear in the file. One in the column 'ventilatiestaat', and 6 rows under the head 'formulierreacties'. The ones in the column 'ventilatiestaat' are not the issue. They come from a lack of data. However, I cannot find the issue in the 6 rows in 'formulierreacties'.
Could someone help me out? That would be great!
Cheers,
Thomas
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.
3 Replies
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!
