Reading File and finding information

[IanMilly]

Hi,

Basically i wish to do a search and find function in a file and use th
information to place data in a secondary file with a matching value.

I have 2 excel files that i want to extract some information from.
I have an excel file which contains lots of different values, fro
values 10001 -40001. In the other excel (old csv) files i have th
same numbers with associated text with it. I want to have the fil
containing the data with text attached searched through and the th
matching data copied to the main excel sheet.

The sheet containing the values and associated text may contai
additional, unrequired data and so only values which match the numbe
values in the main excel file are required.

i.e.

Main File File to be read

Col "A" Col "C" Col "D"

10023 30001 Text A
10024 10023 Text B
10025 39002 Text C
39001 Text D
10024 Text E


Values for text B and Text E are required to be extracted and placed i
the main file (into a new column) where the values in main File (Colum
A) are equal to the values in the read file (Column C).

Any help is greatly appreciated.

Thanks

ia

 

[Dave Peterson]

It sounds like =vlookup() will do what you want.

Take a look at Debra Dalgleish's site for some nice instructions:
http://www.contextures.com/xlFunctions02.html