Hi

I have been given an excel file by a colleague and the B column the
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 stored
locally, but whenever I change the value in the A column the B column
is updated correctly, even though whenever I try to edit the formula I
get the "file not found" dialog.

What I need is the full list of options which are completing the B
column. It must be located somewhere, as there is over 100
possibilities which can be inputted into the A column, and the formula
cell is always updated correctly, without the Grading.xls file!

It's driving me nuts!


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=396393