+ Reply to Thread
Results 1 to 6 of 6

IF #N/A bring over adjacent column's data

  1. #1
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Question IF #N/A bring over adjacent column's data

    attach'd shows scenario -- Col E would hold formula/function -- IF D2 holds #N/A (General formatting) then place contents from C2 into E2
    If not, then keep cell blank as image shows (or if easier, a zero result is fine)

    Thanks!
    bring-over-adjacent-if-na.GIF

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: IF #N/A bring over adjacent column's data

    =if(isna(d2),c2,"")


    Should do the trick.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,415

    Re: IF #N/A bring over adjacent column's data

    Try this:

    =IF(ISNA(D2),C2,"")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,415

    Re: IF #N/A bring over adjacent column's data

    Snap!

  5. #5
    Registered User
    Join Date
    11-03-2004
    Posts
    75

    Re: IF #N/A bring over adjacent column's data

    That's it! Thanks guys for the expeditious help! I gave reputation points to both!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,415

    Re: IF #N/A bring over adjacent column's data

    That's very kind!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Auto-adjust # of rows in a column that have a formula based on adjacent column data?
    By Norcal1 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 05-31-2018, 02:03 PM
  2. Replies: 3
    Last Post: 02-22-2017, 06:26 PM
  3. Replies: 1
    Last Post: 11-07-2016, 09:08 AM
  4. Bring along the neighbouring data into adjacent column
    By raimy haidar in forum Excel General
    Replies: 0
    Last Post: 02-14-2015, 09:21 AM
  5. Formula to bring up corresponding/adjacent cells.
    By evantoast in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2013, 04:16 PM
  6. Replies: 7
    Last Post: 05-15-2012, 03:41 PM
  7. What is the easiest way to bring up data in adjacent cell after s.
    By Jason in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2005, 06: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