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 another WB. In another WB I have the list of trucks from intake report and I want to identify the owner from the list of trucks by bringing the company name.
My formula is looking like that = VLOOKUP (O25; 'LISTA AUTO'! $N$3:$O$2693 ; 1 ; TRUE ) where O25 is the cell with truck number, range to lookup for data is N3:O2693, 1 is the column number to bring and true is the match. If I use false as a match brings me #N/A on all column.
Results is that, my formula doesn't bring correct data meaning wrong owner or showing #N/A.
Evaluation of the formula by step in for #N/A, says that the truck no from O25 is not recognized or found in my list.
The list of trucks are the same used in the intake report, I just used it the same for my simulation.
I want to understand what is wrong with my formula and how to correct it to work out.
I use MS365 and W10 if this is useful.