Forum Discussion
Solved
#N/A in formula from data linked between workbooks
Hello, I have few workbooks which links data from one to another. For example, I have a sheet with list of trucks and owners (company name 1st column and truck plate 2nd column) linked from anothe...
CarmenV From what you describe, I believe you need to look at the 2nd column and use FALSE.
CarmenV From what you describe, I believe you need to look at the 2nd column and use FALSE.
Hi Riny_van_Eekelen,
Thank you for your approach. As I said in my first post, if I use FALSE result is #N/A all column. So, is not workable this way. I believe the origin of my error stays in linked between sheets but cant figure out why and how to fix it.
Thank you for your approach. As I said in my first post, if I use FALSE result is #N/A all column. So, is not workable this way. I believe the origin of my error stays in linked between sheets but cant figure out why and how to fix it.