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