+ Reply to Thread
Results 1 to 3 of 3

missed data

  1. #1
    Registered User
    Join Date
    01-04-2006
    Posts
    3

    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
    Attached Files Attached Files
    Last edited by rjl; 01-05-2006 at 05:20 PM.

  2. #2
    Bart Snel
    Guest

    Re: 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?

  3. #3
    Registered User
    Join Date
    01-04-2006
    Posts
    3

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1