missed data
 

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: http://www.excelforum.com/member.php...o&userid=30117
View this thread: http://www.excelforum.com/showthread...hreadid=498475

missed data
 

rjl schreef:
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


I'd say it's probably deleted. Does the cell which contains this formula
return a value or an error?

missed data
 

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 "B8", the descriptión will show up in cell "F8". I Think this data
is hidden somwhere in the same workbook.


--
rjl
------------------------------------------------------------------------
rjl's Profile: http://www.excelforum.com/member.php...o&userid=30117
View this thread: http://www.excelforum.com/showthread...hreadid=498475