+ Reply to Thread
Results 1 to 3 of 3

Excel formula does not bring back results in all rows

  1. #1
    Registered User
    Join Date
    07-07-2017
    Location
    Florida
    MS-Off Ver
    Excel
    Posts
    2

    Excel formula does not bring back results in all rows

    I have an excel formula that when I copy it down works in some rows but not others. The formula is =CHOOSE(IF(AND(ISBLANK(P:P),ISBLANK(BS:BS)),3,IF(ISBLANK(P:P),2,1)),P:P,BS:BS,"Unknown") The data is blank in column P:P, so it should bring back the data in column BS:BS which it does on some rows but not others. The columns are formatted as General.The data in column BS is from the same source, same format. If I copy data from the working row to the non-working row, I still get blanks. What am I missing?? Thanks!
    Attached Files Attached Files

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

    Re: Excel formula does not bring back results in all rows

    P3:P7 is not blank they are spaces
    P8:P10 is indeed blank
    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.

  3. #3
    Registered User
    Join Date
    07-07-2017
    Location
    Florida
    MS-Off Ver
    Excel
    Posts
    2

    Re: Excel formula does not bring back results in all rows

    Thanks Special-K!! That was quick, I cleared column P in those rows and everything works!! Thank you.
    Joanne

+ 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. Array Formula Lookup - Bring back Lowest Date + Bring Back Cell Location
    By Matt1998 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2014, 12:08 PM
  2. [SOLVED] Display Top 10 Results and bring back certain information to populate fields
    By amasson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2014, 08:37 AM
  3. Enter code into a dropdown list, bring back results
    By thedon_1 in forum Excel General
    Replies: 1
    Last Post: 12-10-2012, 06:10 AM
  4. Replies: 4
    Last Post: 09-04-2012, 03:23 PM
  5. Replies: 6
    Last Post: 01-16-2012, 09:42 AM
  6. Match two cells and bring back the results from a third
    By amyj22x3 in forum Excel General
    Replies: 3
    Last Post: 10-28-2011, 12:50 PM
  7. [SOLVED] Bring back the FORMULA RESULT BAR in excel
    By Howard in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-19-2005, 06:05 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