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.
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 🙂
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 🙂