View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cwilliamson cwilliamson is offline
external usenet poster
 
Posts: 1
Default 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