+ Reply to Thread
Results 1 to 2 of 2

How do I display data from one sheet if blank or another if filled

  1. #1
    Registered User
    Join Date
    06-24-2019
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    1

    How do I display data from one sheet if blank or another if filled

    Hi,

    I need help to display data from one sheet if blank (or other value if that helps) and data from another sheet if the cell has been filled.

    I hope it make sense : )

    Thank you.

    Kind regards
    Krillephar

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: How do I display data from one sheet if blank or another if filled

    "...display data from one sheet if blank...and data from another sheet if the cell has been filled."

    in A1
    =IF(B1="",Sheet1!C1,Sheet2!D1)

    Displays data from one sheet (Sheet1!C1) if blank (B1 is blank), and data from another sheet (Sheet2!D1) if the cell has been filled (B1 is not blank).

    adjust the formula to match your requirements.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Leaving sum cell blank until all data cells are filled
    By Jtwanabe in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-26-2018, 07:04 AM
  2. display blank cell until cells are filled with dates to calcualte days
    By EMcCausland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2016, 10:44 AM
  3. [SOLVED] Count the number of filled rows in sheet 1 and display in sheet 2. Please help
    By krishnaa_kumarr88 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-02-2014, 07:59 AM
  4. Blank Data Fields / Filled to be cut to sheet2
    By mrkbciu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2014, 09:42 AM
  5. Add row with formatting if text in cell OR add blank row filled with blue if blank
    By sierradk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2014, 04:15 AM
  6. Replies: 2
    Last Post: 06-12-2013, 04:14 PM
  7. Replies: 0
    Last Post: 04-20-2005, 04:06 PM

Tags for this Thread

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