| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup: Get a value from a different spreadsheet
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup / index for a large spreadsheet | Excel Worksheet Functions | |||
| how do i setup vlookup to look up in a different excel spreadsheet | Excel Worksheet Functions | |||
| How do I stop VLOOKUP from asking what spreadsheet to look in? | Excel Worksheet Functions | |||
| Can Vlookup from one spreadsheet and not another | Excel Worksheet Functions | |||
| help with vlookup spreadsheet | Excel Worksheet Functions | |||
Threaded Mode
