+ Reply to Thread
Results 1 to 2 of 2

Trying to return Linked Cells blank when blank.

  1. #1
    Registered User
    Join Date
    09-08-2011
    Location
    Denver, CO
    MS-Off Ver
    Excel 2003
    Posts
    1

    Trying to return Linked Cells blank when blank.

    I have cells linked between two different workbooks. I simply want to copy one cell to the other, however I would like when a cell in workbook A is blank then returns blank on workbook B instead of returning as 0. I believe you can use an IF function and possibly in conjunction with the EXACT function as well. I think I am close but the following returns as a #VALUE! error. Any help would be appriciated.

    =IF('[Line List & Piping Isometric List.xlsx]List'!K8,(EXACT('[Line List & Piping Isometric List.xlsx]List'!K8,'[Line List & Piping Isometric List.xlsx]List'!K8)),"")

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Trying to return Linked Cells blank when blank.

    This will help you sort that out http://www.thecodecage.com/forumz/ex...tml#post563726
    Not all forums are the same - seek and you shall find

+ 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