Re: Can I cross reference Excel files with each other?

John,
If you put the following formula in B37 of  excelONE
=VLOOKUP(A37,[excelTWO.xls]Sheet1!$A:$B,2,FALSE)
(replace Sheet1 with the name of the sheet in excelTWO which has the lookup
values in.
You can copy the formula to other cells in column B as required.
Hope that helps,
Barbara.

"John Kelly" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Question for any Excel Guru out there.
>
> I have two Excel files, ExcelONE and ExcelTWO. Both of thes have, or
> can accept, numbers in the A column and text in the B column. Is it
> possible to type a number into any A cell (e.g. A37) of ExcelONE, and
> for Excel to automatically find a matching value in an A cell of
> ExcelTWO, and then copy the value text from the B cell of ExcelTWO
> into the B cell of ExcelONE.
>
> For example, if I type 4158 into A37 of ExcelONE, and I know the value
> 4158 exists (uniquely) in an A cell of ExcelTWO, can Excel find which
> row it is in (lets say it finds it in A1234, can Excel then copy the
> text from B1234 into B37 of ExcelONE?