+ Reply to Thread
Results 1 to 4 of 4

In cell C2, pull value from A2, but if blank or error, pull value from B2.

  1. 12-04-2013, 01:51 PM #1
    shepherdc2814
    shepherdc2814 is offline
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    In cell C2, pull value from A2, but if blank or error, pull value from B2.

    Hello all,

    See the example that I've attached which illustrates what I'm trying to do. In Cell C2, I want to pull the value from A2, but if cell A2 is blank or contains the #DIV/0! error, I want to pull the value from cell B2.

    I hope that makes sense. Let me know if I'm not being clear. Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-04-2013, 01:54 PM #2
    Jakobshavn
    Jakobshavn is offline
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: In cell C2, pull value from A2, but if blank or error, pull value from B2.

    try:

    =IF(ISERROR(A2),B2,IF(A2="",B2,A2))
    Gary's Student
    Reply With QuoteRegister To Reply
  3. 12-04-2013, 04:02 PM #3
    shepherdc2814
    shepherdc2814 is offline
    Registered User
    Join Date
    04-16-2013
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: In cell C2, pull value from A2, but if blank or error, pull value from B2.

    Perfect, thank you!!
    Reply With QuoteRegister To Reply
  4. 12-05-2013, 09:42 AM #4
    Jakobshavn
    Jakobshavn is offline
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: In cell C2, pull value from A2, but if blank or error, pull value from B2.

    You are quite welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel Formula to pull data from another sheet and place cell blank if value is 0
    By szpt9m in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 09-18-2013, 01:07 AM
  2. Formula to pull data from left column next to the 1st blank cell in the right column
    By latisha514 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-04-2013, 11:25 AM
  3. [SOLVED] Simple pull exact text from cell, if blank it pulls up a 0. How to leave it as blank?
    By sharpmel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2012, 02:20 PM
  4. [SOLVED] How to use two pull down lists to pull information from a third table
    By RibbleValley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2012, 07:45 AM
  5. Country of Origin pull down to pull over
    By j0k3rk1ll3r in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2011, 12:39 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1