Filling Text from Another File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lost in charts - 02 Dec 2005 14:54 GMT

Hello,
I have two Excel files. There is text information in one file on one
column which I would like to transfer to another file. However, the info
must match the a specific row. Example:

File 1
Column A Column B
TSFM HC
ADCT TECH
COMS TECH
etc....

File 2
Column A Column B
ADCT (Would like to get info from File 1)
COMS
TSFM

In essence, in File 2, I would like to fill Column B with data from File 1
that corresponds to the labels in Column A. I have tried the IF function,
but have not been able to get that to work.

Any help would be MUCH appreciated?

Thanks,
Kit

Reply to this Message

David Billigmeier - 02 Dec 2005 15:21 GMT

Take a look at VLOOKUP() in the help menu, this will accomplish what you are
looking for.

Signature

Regards,
Dave

> Hello,
> I have two Excel files. There is text information in one file on one
[quoted text clipped - 22 lines]
> Thanks,
> Kit

Reply to this Message

lost in charts - 02 Dec 2005 16:27 GMT

I am completely confused about how this function works. I am using the
function wizard to fill in the "fields" but I am doing it incorrectly because
the formula shows up in the cell, not the desired result.

More help please!

> Take a look at VLOOKUP() in the help menu, this will accomplish what you are
> looking for.
[quoted text clipped - 25 lines]
> > Thanks,
> > Kit

Reply to this Message

David Billigmeier - 02 Dec 2005 16:47 GMT

Alright. First, I'll make a couple assumptions as to the naming conventions
you are using because you didn't specify (I don't think, atleast):

1) Your "File 1" is literally named "File 1.xls"
2) Your "File 2" is literally named "File 2.xls"
3) The tab name that the information in "File 1" is stored on is "Sheet1"
4) The tab name that the information in "File 2" is stored on is "Sheet1"
5) Your information starts on row 1 in both sheets

With all these above conditions, this formula, placed in B1, of tab "Sheet1"
in "File 2.xls" will work:

=VLOOKUP(A1,'[File 1.xls]Sheet1'!$A$1:$B$3,2,0)

Now, change the '3' in $B$3 to the last row of your data range in "File
1.xls", and drag this formula down to the end of your data in "File 2.xls"

Is that better?

Signature

Regards,
Dave

> I am completely confused about how this function works. I am using the
> function wizard to fill in the "fields" but I am doing it incorrectly because
[quoted text clipped - 31 lines]
> > > Thanks,
> > > Kit

Reply to this Message

lost in charts - 02 Dec 2005 17:29 GMT

Unfortunately, the two files are not in unison. The information that I am
looking for is in column T of File 1 and it needs to fill column F of File 2.
Does that matter? I took your formula and changed the range to cover the
entire worksheet of File 1 and changed the 2 to 20, which is the column
number of T. However, the formula is still showing up in the cell.

> Alright. First, I'll make a couple assumptions as to the naming conventions
> you are using because you didn't specify (I don't think, atleast):
[quoted text clipped - 50 lines]
> > > > Thanks,
> > > > Kit

Reply to this Message

David Billigmeier - 02 Dec 2005 18:29 GMT

Did you include an equal's sign (=) before the formula?

Signature

Regards,
Dave

> Unfortunately, the two files are not in unison. The information that I am
> looking for is in column T of File 1 and it needs to fill column F of File 2.
[quoted text clipped - 56 lines]
> > > > > Thanks,
> > > > > Kit

Reply to this Message

lost in charts - 02 Dec 2005 19:46 GMT

Yes.

> Did you include an equal's sign (=) before the formula?
>
[quoted text clipped - 58 lines]
> > > > > > Thanks,
> > > > > > Kit

Reply to this Message