Forum Discussion
CarmenV
Jun 11, 2021Copper Contributor
#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...
- Jun 11, 2021
CarmenV From what you describe, I believe you need to look at the 2nd column and use FALSE.
Andre_nl
Jun 11, 2021Copper Contributor
Carmen,
For the vlookup function, the lookup value in your lookup data, should be in the first colmn. In your situation the lookup value is in column 2.
If you change the list of trucks to truck plate in column 1 and company name in 2, you can return colmn 2 as name. You should use flase to get only exact maches.
If you cannot change the lookup table you could try xlookup or, in case you have an older version of Excel, you can used Index Match function.
For the vlookup function, the lookup value in your lookup data, should be in the first colmn. In your situation the lookup value is in column 2.
If you change the list of trucks to truck plate in column 1 and company name in 2, you can return colmn 2 as name. You should use flase to get only exact maches.
If you cannot change the lookup table you could try xlookup or, in case you have an older version of Excel, you can used Index Match function.
CarmenV
Jun 11, 2021Copper Contributor
Andre_nl , I did and is working. My comments above are in respect of this answer. Thank you too, to be involved in my question.