vlookup between excel files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top