Compile error: Argument not optional

I want to start by saying I'm very new to macros so this may be a stupid question. I tried to run this macro here

Please Login or Register  to view this content.

But when I try to use it, I get the error: Compile error: Argument not optional

I have attached the workbook I'm trying to do this in. The command I use is =VLOOKUPWORKBOOK1(A3, 'TS-5D1'!D3:D103, 4, 0) and is found on the Materials List tab in cell D3.

Any help you could give would be great!

Not throwing any error for me except the fact that the line before "End Function" is "VLOOKUPWORKBOOK" when it should be "VLOOKUPWORKBOOK1" to match the name of your function.

Now when I try this, it says please update TS-5D1. What does this mean and what should I do?

Well I'm not getting an error but it is just returning a zero. I've attached the updated version here. Could you take a look and see if you can figure it out?

This is starting to look good! Any idea why it is returning the numbers under quantity instead of the item description for some of the entries?

Well that was silly. So I removed 'Master List' and corrected a few of the numbers but it still isn't working. When I try to set a custom amount of zero's using the cell number format option, it simply doesn't respond. Also, I adjusted the column parameter to 4 and it is just returning #value!. I just wanted to add that I really appreciate your help thus far!

I've attached the most recent copy.

I love you so much right now! I really appreciate you being so patient with me. One last question. Why is it that when I try to format the numbers under the 'code number' to all resemble the pattern of xxxx-xx-xx it just doesn't respond? I would like it so they all have the leading zeros so that they fit that xxxx-xx-xx pattern.

Well then I think I'm all set! I just want to thank you again for all your help! You are amazing!!!