D
dziw
Hi
I have been given an excel file by a colleague and the B column th
cells contain the following formula
=IF(A*xx*>0,VLOOKUP(A23,'C:\QA\References\[Grading.xls]Grading'!$A$1:$AD$502,2,FALSE),""
-where xx is the row number-
Now I do not have the 'C:\QA\References\[Grading.xls]' file store
locally, but whenever I change the value in the A column the B colum
is updated correctly, even though whenever I try to edit the formula
get the "file not found" dialog.
What I need is the full list of options which are completing the
column. It must be located somewhere, as there is over 10
possibilities which can be inputted into the A column, and the formul
cell is always updated correctly, without the Grading.xls file!
It's driving me nuts
I have been given an excel file by a colleague and the B column th
cells contain the following formula
=IF(A*xx*>0,VLOOKUP(A23,'C:\QA\References\[Grading.xls]Grading'!$A$1:$AD$502,2,FALSE),""
-where xx is the row number-
Now I do not have the 'C:\QA\References\[Grading.xls]' file store
locally, but whenever I change the value in the A column the B colum
is updated correctly, even though whenever I try to edit the formula
get the "file not found" dialog.
What I need is the full list of options which are completing the
column. It must be located somewhere, as there is over 10
possibilities which can be inputted into the A column, and the formul
cell is always updated correctly, without the Grading.xls file!
It's driving me nuts