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