Double Vlookup Formula in VBA

Hello,

I am trying to get the code below to look up/copy size values, by material, from one worksheet (Footwear Non-Sch. Buy Template) and paste them to another (Winshuttle). The size values on the template worksheet are listed in a named range called "SizeGrid". The code should look up the size value from the size grid, by material number, and paste it in the corresponding material line size cell, starting with size 1, on the Winshuttle worksheet. The size columns on the Winshuttle worksheet alternate columns. The line of code that is commented out is the previous code without the double vlookup. The line above that is the new code that I am trying to update.

Please see attached file...

Please Login or Register  to view this content.

I was able to solve this on my own after some work...

Please Login or Register  to view this content.