Im trying to write up a funtion on vba that will give an
answer based on a workbook saved on a specific path on my
pc. How do I call a fixed workbook up on a function.

The function will look for a value always in this
spreadsheet, and will work like a double vlookup, the
matrix where it will look up has colums Date | Bench | Part
the output of the function will be the part when I give
Date & Bench i.e. =Part(date,bench) on excel will give the
part that was produced on that day and bench per the
hidden workbook database.

Any help is greatly apreciate.

Regards
JS