+ Reply to Thread
Results 1 to 12 of 12

IFERROR & CONCATENATE Problem

  1. #1
    Registered User
    Join Date
    07-02-2015
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    10

    Question IFERROR & CONCATENATE Problem

    Hello all, I hope you can help me. I am a bit of a novice when it comes to complex formulas. I am trying to write the formula (see image) to achieve the text below it but its just not accepting my arguments.

    Can anybody assist?


    formula_img.png

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: IFERROR & CONCATENATE Problem

    You get better result on your question if you add a small excel file, without confidential information.

    Please also add the expected results manualy in your file.

    P.s. we need new glasses to read your attachement.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    07-02-2015
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    10

    Re: IFERROR & CONCATENATE Problem

    Hi, thanks for your reply. I cant upload any files on here, only images?

    Maybe this will help? Slightly zoomed 17-06-2017 15-46-20.png

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: IFERROR & CONCATENATE Problem

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.

  5. #5
    Registered User
    Join Date
    07-02-2015
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    10

    Re: IFERROR & CONCATENATE Problem

    Quote Originally Posted by oeldere View Post
    To Attach a File:


    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Thanks for this, i did need to select "Go Advanced" first before i could access the additional options.

    I have now uploaded an excel file. Can you see it?
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: IFERROR & CONCATENATE Problem

    Yes we can see it, but

    add in your file manualy the result.

    Show us the related cells so we can see what is going on.

  7. #7
    Registered User
    Join Date
    07-02-2015
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    10

    Re: IFERROR & CONCATENATE Problem

    Quote Originally Posted by oeldere View Post
    Yes we can see it, but

    add in your file manualy the result.

    Show us the related cells so we can see what is going on.
    I did add manually the result? The related cells are A2 and B2. Attached again.
    Attached Files Attached Files

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: IFERROR & CONCATENATE Problem

    I did add manually the result? The related cells are A2 and B2. Attached again.
    but where do we find the data in your file, to get the result/

    Which cells are related?

  9. #9
    Registered User
    Join Date
    07-02-2015
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    10

    Re: IFERROR & CONCATENATE Problem

    Cells A2 & B2 are the only cells required in the formula.

  10. #10
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: IFERROR & CONCATENATE Problem

    So all you want is to concatenate A2 & B2?
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B C
    1 Account Date
    2 name 7/10/2017 name20170710
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  11. #11
    Registered User
    Join Date
    07-02-2015
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    10

    Re: IFERROR & CONCATENATE Problem

    Quote Originally Posted by AlKey View Post
    So all you want is to concatenate A2 & B2?
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    v A B C
    1 Account Date
    2 name 7/10/2017 name20170710
    No, there is other text which needs to be concatenated into the formula. The text will always stay the same, its the contents of cells A2 & B2 which will change.

    form.png

  12. #12
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: IFERROR & CONCATENATE Problem

    can't respond on this one.

    I can't add the formula in this item. Internet does not allow me.

    See the attached file.
    Last edited by oeldere; 06-17-2017 at 02:02 PM.

+ 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] =iferror problem
    By Topher53180 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-12-2014, 11:39 PM
  2. [SOLVED] IFERROR problem
    By johnhasaquestion in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-13-2013, 08:49 AM
  3. IFERROR problem
    By astole in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-30-2013, 04:31 AM
  4. [SOLVED] IFERROR problem
    By wdan57 in forum Excel General
    Replies: 2
    Last Post: 05-24-2013, 11:45 AM
  5. [SOLVED] Using VLOOKUP and CONCATENATE within an IFERROR formula
    By mowens74 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2013, 12:24 PM
  6. [SOLVED] Max/Min IfError Problem
    By Montoro22 in forum Excel General
    Replies: 10
    Last Post: 08-07-2012, 02:33 PM
  7. Syntax Iferror Problem
    By benno87 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2009, 12:09 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1