Hi All,
I am trying to look up info that is in a different spreadsheet.
I have a "c:\PartMaster.xls" spreadsheet that has 3 columns: PartNumber,
Description, Cost. I have a second spreadsheet that is a parts list for a
specific machine. In the PartsList.xls spreadsheet I want to enter the part
number, then get the description and cost from the PartMaster spreadsheet.
I don't know how to write the VLookup() function to go to a different
spreadsheet. Can anyone help me out? Thanks!