missed data

R

rjl

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
 
B

Bart Snel

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?
 
R

rjl

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top