| 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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLookup: Get a value from a different spreadsheet
Try this
=VLOOKUP(A2,[Book2]Sheet1!$A$1:$B$33,2,FALSE) Where Book2 is the name of the second workbook Mike "Simon" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLookup: Get a value from a different spreadsheet
Thanks for the Reply, Mike, but that doesn't seem to work. I still get an
error. I figured something out that does seem to work correctly: IF(ISBLANK(A2)," ",VLOOKUP(A2,'C:\[PartMaster.xls]Sheet1'!A:C,2,FALSE)) "Mike H" wrote: Try this =VLOOKUP(A2,[Book2]Sheet1!$A$1:$B$33,2,FALSE) Where Book2 is the name of the second workbook Mike "Simon" wrote: 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLookup: Get a value from a different spreadsheet
Excel does not have spreadsheets. Excel has workbooks. Workbooks have
worksheets. Worksheets have tabs. So, since I have no idea what you mean by "spreadsheet" I cannot answer you. Tyro "Simon" wrote in message ... 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! |
| Reply |
| 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 | |||
Linear Mode
