Hi
Can I use vlookup to search for data over several workbooks?

For example look for a part number which could be stored in seperate
workbooks for different manufacturers.

If so can someone give me an example?

Many thanks.