I have a work book that has up to 100 pages on the first page I have list og materials on all the other pages I import a list of parts that use those materials. I wish to find the parts in the list by matching the material name
in the parts list with the name in the material list and extract the price in a corresponing column
in the parts list with the name in the material list and extract the price in a corresponing column