I am using Vlookup example =VLOOKUP(E10,A18:B50,2)
to select a description of a product but it works for some lines but not others.
When it doesn't work it tends to select the last descriptions for the product (ie field A18 will correctly select field B18 and so forth until it gets to say A25 which will incorrectly select B50 and so on). The product numbers are a little complex such as
ABD10050CNR-XX (ski041)
with a description of
Bench Duct Int/Ext Corner.
Is this not working because the product numbers and descriptions are to complex/messy?