I am trying to create a function that will get the Category in the second row of my Size_Category_List array while using the Weight field as the lookup value.
So really what I would like to do is on my Shipping Data sheet in I16 whatever the weight is to correspond to a matching size category which is found on the Input Data sheet starting at A24. I tried using HLOOKUP with no luck.
Bookmarks