Help with a vlookup through entire workbook macro

[lulu319]

I'm trying to use a macro that will search the entire workbook. Here is the macro I'm using:

Please Login or Register  to view this content.

When I call the function I use this: =VLOOKUPWORKBK(A3,$A$3:$A$103, 4, 0) but it just returns a zero everytime.

I have attached the workbook. You will find the function on the "materials list" sheet in cell d3.

Any help would be appreciated!

[tehneXus]

Duplicate Thread? http://www.excelforum.com/excel-prog...-optional.html

[arlu1201]

Thanks

Duplicate thread.