Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup between excel files
How do I do this?
For examle. I have a column A in file 1. I want to write data to column B in file 1. File 2 column A has almost the same columns as column A. I want to match column A in file 1 with column A in file 2. Then I want the data in a file 2 column A to go to a specified column in file 1. Maybe an example file 1 A B 111 112 115 118 file 2 A B 111 $30 113 $50 115 $20 117 $60 118 $40 How do I get the values costs in file 2 column B to go to file 1 column B in the corresponding column. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup between excel files
Try a formula like
=VLOOKUP(A1,[B.xls]Sheet1!$A$1:$D$4,2,FALSE) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "cwilliamson" wrote in message ... How do I do this? For examle. I have a column A in file 1. I want to write data to column B in file 1. File 2 column A has almost the same columns as column A. I want to match column A in file 1 with column A in file 2. Then I want the data in a file 2 column A to go to a specified column in file 1. Maybe an example file 1 A B 111 112 115 118 file 2 A B 111 $30 113 $50 115 $20 117 $60 118 $40 How do I get the values costs in file 2 column B to go to file 1 column B in the corresponding column. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup between excel files
Your description of your problem is rather confusing, so let's try this:
In order to use VLOOKUP, you need to have a list /database in an Excel worksheet. This will eg contain say part numbers in Col A, a description in Col B, a cost price in Col C, and a selling price in Col D, just for the sake of illustration. You can change this around as you wish. The list must be sorted per Col A, and you should name the range containing this info, in this case, for argument's sake, from A1:D100. You can eg call it Parts - Insert|Name|Define, type in Partes and OK out. In the sheet where you want to use VLOOKUP, you will enter the part number, say in Col A. In the column (you mentioned B) where you want the price, you then enter the VLOOKUP formula to retrieve the info you are looking for. In this case, your info is in Col D, which is offset 4 columns. Your formula would then be, if we are working in Row 2, and in B2 specifically: =VLOOKUP(A2,Parts,4,FALSE) In A2 you have your number - 113. Vlokup then looks up this number in the Parts range, retrieves the value in Col D, and returns that in B2. You can of course use =VLOOKUP(A2,Parts,2,FALSE) to also retrieve the description of the item. "cwilliamson" wrote: How do I do this? For examle. I have a column A in file 1. I want to write data to column B in file 1. File 2 column A has almost the same columns as column A. I want to match column A in file 1 with column A in file 2. Then I want the data in a file 2 column A to go to a specified column in file 1. Maybe an example file 1 A B 111 112 115 118 file 2 A B 111 $30 113 $50 115 $20 117 $60 118 $40 How do I get the values costs in file 2 column B to go to file 1 column B in the corresponding column. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to MATCH or VLOOKUP & copy using 2 excel files | Excel Worksheet Functions | |||
macro vlookup between 2 files | Excel Discussion (Misc queries) | |||
VLOOKUP linking to different files | Excel Worksheet Functions | |||
Using VLOOKUP across multiple files | Excel Worksheet Functions | |||
vlookup to other files | Excel Worksheet Functions |