Lookup data in another Excel file

  • Thread starter Thread starter mooser123
  • Start date Start date
M

mooser123

Working in Excel 97. This should be pretty simple but I need help.

I have a list of projects in Excel. It contains two columns. The fil
is called ProjectList.xls.
Project ID
Project Name

I want to link a separate project tracking excel file (called Projec
Tracking Template.xls) to this list, so that when I go to my Projec
Tracking.xls file, and type in the Project ID, it pre-fills the Projec
Name.

Have hit a dead end using the lookup wizard, it almost seems more lik
I need to use V lookup or Hlookup or something else?

I've made the column headings labels, but that does not help.

These are the steps I've taken:
Tools-Lookup Wizard-
Range that contains the data: $A$1:$D$5
Then it asks me for the range to search - either column or the row. N
matter which I choose it comes back with an error:
"the cell found by the wizard contains a formula returning an error
Please exit the wizard and fix your table".
Huh? There is no formula in the cell.

Thanks for any help you can give
 
Hi mooser123

below a example that use VLOOKUP in a other closed workbook
=VLOOKUP(A1,'C:\data\[test1.xls]Sheet1'!$A$1:$B$25,2,FALSE)

This example will search the a1 value in A1:A25 of sheet1 in test1.xls and
display the value in the B column
 
Back
Top