+ Reply to Thread
Results 1 to 4 of 4

Formula to return text if another cell is blank

  1. #1
    Forum Contributor
    Join Date
    06-30-2008
    Location
    london
    Posts
    108

    Formula to return text if another cell is blank

    Hi there,

    I am trying to sort some data and return a value based on criteria.

    I want to return the value in column K, but if column K is blank then return the value in column L, but if column L is blank return the value in column M.

    I was trying to do a IF statement but I kept getting errors. It sounds like it should be easy!

    any ideas?

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula to return text if another cell is blank

    Assuming you're constructing a "helper column" and you'll sort on that...
    Try this regular formula, copied down:
    N2: =INDEX(K2:M2,MATCH("*",K2:M2,0))

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Formula to return text if another cell is blank

    Try:

    =IF(K1<>"",K1,IF(L1<>"",L1,M1))
    Gary's Student

  4. #4
    Forum Contributor
    Join Date
    06-30-2008
    Location
    london
    Posts
    108

    Re: Formula to return text if another cell is blank

    Awesome thanks for the responses guys. I went with Rons formula, it worked well.

    Thanks heaps!

+ 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. Index/ Match Formula, How to return blank cell as a blank not 0
    By MDResearcher in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-24-2016, 08:40 PM
  2. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  3. If formula to return blank if reference cell blank
    By dhooper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2013, 08:56 PM
  4. [SOLVED] Need formula to return blank instead of #N/A when source cell is blank, using VLOOKUP
    By TMB1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2013, 07:16 PM
  5. Return blank if Cell is blank or contains formula)
    By oo0tommyk0oo in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-22-2011, 05:31 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