+ Reply to Thread
Results 1 to 4 of 4

if cell contains text then return that text if blank return value of another cell

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    Newcastle upon Tyne, United Kingdom
    MS-Off Ver
    Excel 365
    Posts
    77

    if cell contains text then return that text if blank return value of another cell

    Morning,

    I'm sure someones already solved this but i cant find the answer this morning.

    I'm looking to check a cell (H2) and if it has a value in it to display that value but if its blank then to display the value of cell (F2)

    Can someone help me with the syntax, i'm sure its an IFError type formula but i'm not sure.

    Thanks.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: if cell contains text then return that text if blank return value of another cell

    Try this:

    =IF(H2<>"",H2,F2)

    BSB

  3. #3
    Registered User
    Join Date
    02-13-2014
    Location
    Newcastle upon Tyne, United Kingdom
    MS-Off Ver
    Excel 365
    Posts
    77

    Re: if cell contains text then return that text if blank return value of another cell

    You're an absolute star, Thank you!

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: if cell contains text then return that text if blank return value of another cell

    No problem. Happy to help

    BSB

+ 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. [SOLVED] If column cell contains text return that text OR if blank return text from cell above
    By Doolski in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-07-2019, 07:16 AM
  2. Replies: 6
    Last Post: 06-13-2019, 09:07 PM
  3. [SOLVED] If #N/A, then return a blank cell, not a null text string
    By AndreaJean18 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2014, 09:58 AM
  4. [SOLVED] Formula to return text if another cell is blank
    By nicko54 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2013, 08:00 PM
  5. If cell contains text1, text2 or text 3 return this text, otherwise return X
    By bukmanodrama in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2013, 09:24 AM
  6. Replies: 2
    Last Post: 09-25-2012, 01:48 PM
  7. Replies: 5
    Last Post: 02-18-2007, 06:30 PM

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