+ Reply to Thread
Results 1 to 3 of 3

Cell function problem

  1. #1
    Registered User
    Join Date
    10-02-2003
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    45

    Cell function problem

    The below formula is to return the quantity of the product from another sheet.
    =VLOOKUP(MID(CELL("filename"),FIND("[",CELL("filename"),1)+1,10),'Z:\PartList\[DESC.XLS]Sheet1'!$A:$C,3,0). I have individual sheets for products and one master sheet for quantity.All the file name for the products is the file name itself. So I can use the above formula.
    But the problem is when I press F9 for one product, the quantity for that product is applied to all the open files with the above formula. I know the problem is with =Cell("filename").
    Hope the problem is explained well. Need attachments? Any solution to stop changing quantity in all open files.
    Thanks,
    Itty.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Rather than CELL("filename") you need to use a cell reference (any cell reference) otherwise the filename given is for filename of the last cell you changed, so try changing your 2 CELL functions to

    CELL("filename",A1)

  3. #3
    Registered User
    Join Date
    10-02-2003
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    45

    thanks

    Cool tip. I was afraid that whether somebody will be able to understand my problem.
    Thanks for your guidence.

+ 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