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 |
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 |