My French is gone many years ago, but perhaps you can translate. Pecoflyer's is much better and his answer is correct. The value you are looking for in your vlookup equation must be in the first column of the range in which you are searching.
Also, you may want to consider using data validation to make a dropdown for you selection of base diameter. See attached.
|