Forum Discussion
Re: #N/A in formula from data linked between workbooks
CarmenV From what you describe, I believe you need to look at the 2nd column and use FALSE.
4 Replies
- After many tries by reducing/changing the range area and revers the columns, my formula at the end is working properly as you said with FALSE and 2nd column.
So formula now is =VLOOKUP(O25;'LISTA AUTO'!$B$3:$C$2693;2;FALSE)
Thanks Riny_van_Eekelen - You gave me reason to continue and find the way 🙂 - 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.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.
