When i use VLOOKUP functions with a range poiting to an external spreadsheet, it gives me errors and ##VALUE responses in my selected fields.
Here is the function i am using:
=VLOOKUP(A5,week1.xls!$A$1:$A$10,1)
where:
-A5 is the word i am searching
-week1.xls is the external spreadsheet
-$A$1:$A$10 is the range i am using
-1 is the column i am getting the result from
Thanx
Here is the function i am using:
=VLOOKUP(A5,week1.xls!$A$1:$A$10,1)
where:
-A5 is the word i am searching
-week1.xls is the external spreadsheet
-$A$1:$A$10 is the range i am using
-1 is the column i am getting the result from
Thanx