software

The following Vlookup formula has this link to another workbook
supposedly in the same folder where the workbook is placed, but there
is no such a file with this name, where is this DATA.xls stored=BUSCARV($B76;'C:\Documents and Settings\rjimenez\Mis
documentos\[DATA.xls]Recursos'!$B$2:$E$1501;2;FALSO)

thanks for your help--
rjl
------------------------------------------------------------------------
rjl's Profile: www.excelforum.com/member.php...oamp;userid=30117
View this thread: www.excelforum.com/showthread...hreadid=498475rjl schreef:
gt; The following Vlookup formula has this link to another workbook
gt; supposedly in the same folder where the workbook is placed, but there
gt; is no such a file with this name, where is this DATA.xls stored
gt;
gt;
gt; =BUSCARV($B76;'C:\Documents and Settings\rjimenez\Mis
gt; documentos\[DATA.xls]Recursos'!$B$2:$E$1501;2;FALSO)
gt;
gt; thanks for your help
gt;
gt;
I'd say it's probably deleted. Does the cell which contains this formula
return a value or an error?


I guess not, the workbook is working properly you can test it by
yourself downloading the attached file. for instance if you type 115 in
cell quot;B8quot;, the descriptión will show up in cell quot;F8quot;. I Think this data
is hidden somwhere in the same workbook.--
rjl
------------------------------------------------------------------------
rjl's Profile: www.excelforum.com/member.php...oamp;userid=30117
View this thread: www.excelforum.com/showthread...hreadid=498475