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

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


--
Regards,
Dave


"lost in charts" wrote:

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

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!

"David Billigmeier" wrote:

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


--
Regards,
Dave


"lost in charts" wrote:

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

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?
--
Regards,
Dave


"lost in charts" wrote:

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!

"David Billigmeier" wrote:

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


--
Regards,
Dave


"lost in charts" wrote:

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

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.

"David Billigmeier" wrote:

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?
--
Regards,
Dave


"lost in charts" wrote:

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!

"David Billigmeier" wrote:

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


--
Regards,
Dave


"lost in charts" wrote:

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

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


--
Regards,
Dave


"lost in charts" wrote:

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.

"David Billigmeier" wrote:

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?
--
Regards,
Dave


"lost in charts" wrote:

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!

"David Billigmeier" wrote:

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


--
Regards,
Dave


"lost in charts" wrote:

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

Yes.

"David Billigmeier" wrote:

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


--
Regards,
Dave


"lost in charts" wrote:

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.

"David Billigmeier" wrote:

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?
--
Regards,
Dave


"lost in charts" wrote:

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!

"David Billigmeier" wrote:

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


--
Regards,
Dave


"lost in charts" wrote:

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