LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to MATCH or VLOOKUP & copy using 2 excel files Sandeep Excel Worksheet Functions 3 October 25th 08 06:29 PM
macro vlookup between 2 files orquidea Excel Discussion (Misc queries) 4 July 15th 08 06:51 PM
VLOOKUP linking to different files Alonso Excel Worksheet Functions 2 December 6th 07 05:04 PM
Using VLOOKUP across multiple files Dave T at home Excel Worksheet Functions 1 November 3rd 05 02:04 PM
vlookup to other files Brad Excel Worksheet Functions 0 January 24th 05 02:39 PM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"