SearchV on text
Solved
archibaldlecter
Posted messages
6
Status
Membre
-
archibaldlecter Posted messages 6 Status Membre -
archibaldlecter Posted messages 6 Status Membre -
Good evening everyone,
During my logistics internship, I am organizing consumption data over 5 years.
Each consumption has two entries: a nomenclature and a designation. A first VLOOKUP on the nomenclatures runs into a problem: some are identical for two differently named products. In short, I want my search to focus on the product names, not the nomenclatures.
However, my VLOOKUP stops working (N/A, arrgh).
=VLOOKUP($A4;nom2008;3;0) - works with 40105000000
The same
=VLOOKUP($B4;nom2008;3;0) - does not work anymore with HUILE SYNTHETIQUE H-537
Of course, I would like to attach a part of the file to make it clearer... but I can't find how to do it!
During my logistics internship, I am organizing consumption data over 5 years.
Each consumption has two entries: a nomenclature and a designation. A first VLOOKUP on the nomenclatures runs into a problem: some are identical for two differently named products. In short, I want my search to focus on the product names, not the nomenclatures.
However, my VLOOKUP stops working (N/A, arrgh).
=VLOOKUP($A4;nom2008;3;0) - works with 40105000000
The same
=VLOOKUP($B4;nom2008;3;0) - does not work anymore with HUILE SYNTHETIQUE H-537
Of course, I would like to attach a part of the file to make it clearer... but I can't find how to do it!
