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.
CarmenV Wait a minute. Trying to visualise your schedule. You say to have the the name in the first column and the plate in the second. And you look up the plate to find the name. Then you need to move the plate column towards the left of the name column and then look at the 2nd column with FALSE.
EDIT: Alternatively, see if your Excel supports XLOOKUP.
If this all seems nonsense, please upload your schedule to avoid any further confusion.
- Riny_van_Eekelen I did so and is working. I understood later on your 1st comment. VL formula is ALWAYS looking from left to right 🙂 Thank you again for your support.