+ Reply to Thread
Results 1 to 8 of 8

IFERROR formula combined with left function

  1. #1
    Registered User
    Join Date
    02-03-2015
    Location
    California
    MS-Off Ver
    Excel 365
    Posts
    18

    Question IFERROR formula combined with left function

    Hello,

    In need of assistance with advancing or changing my current excel formula.
    'm using an IFERROR function and coming up with a bank which is a true result based on the data.
    However, how can I add to my formula to view another cell and return the left five values from that data description?

    Current formula: =IFERROR(INDEX('My Project Data'!$I$2:$I$71659,MATCH($D2,'My Project Data'!$J$2:$J$71659,0)),"NO Order")
    (if the result is a blank in "C3" of Purchase Order tab, can a formula look at cell E3 and bring over the first 5 numbers of that text description)
    Answer would be: 89054.
    Thank you!!!!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: IFERROR formula combined with left function

    Are you still with Excel 2016?
    Because it will make great difference in the answer you receive.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by DJunqueira; 03-28-2024 at 07:27 PM.

  3. #3
    Registered User
    Join Date
    02-03-2015
    Location
    California
    MS-Off Ver
    Excel 365
    Posts
    18

    Re: IFERROR formula combined with left function

    No, im using Microsoft 365

  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
    80,869

    Re: IFERROR formula combined with left function

    Update our forum profile NOW, please.
    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.

  5. #5
    Registered User
    Join Date
    02-03-2015
    Location
    California
    MS-Off Ver
    Excel 365
    Posts
    18

    Re: IFERROR formula combined with left function

    Thank you for the feedback DJ, im trying out the formula now,,,ill provide an update in a few minutes.

  6. #6
    Registered User
    Join Date
    02-03-2015
    Location
    California
    MS-Off Ver
    Excel 365
    Posts
    18

    Re: IFERROR formula combined with left function

    Hi Ali, im not sure how to update the forum?

  7. #7
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: IFERROR formula combined with left function

    Click on UserCP in the dark blue menu bar near the top of the screen.

    Then you can click on Edit Profile under the My Settings panel on the left-hand side of the screen. Make the necessary changes there.

    Hope this helps.

    Pete

  8. #8
    Registered User
    Join Date
    02-03-2015
    Location
    California
    MS-Off Ver
    Excel 365
    Posts
    18

    Re: IFERROR formula combined with left function

    Thank you, Pete!

+ 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 combined with a IF statement
    By SeniorRX in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-06-2022, 02:46 PM
  2. Replies: 3
    Last Post: 08-10-2021, 10:49 AM
  3. IFError and IFaverage statement (combined)
    By Lukhanyo in forum Excel General
    Replies: 4
    Last Post: 11-04-2020, 09:22 PM
  4. [SOLVED] ATAN Function returns FALSE (when IFERROR added) and DIV/0 when left
    By aabbey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2018, 09:05 AM
  5. Vlookup, Left and MID combined?
    By Bedhead in forum Excel General
    Replies: 12
    Last Post: 05-02-2017, 08:39 AM
  6. VBA - Index formula to be combined using IFERROR
    By gan_xl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2014, 06:15 AM
  7. Combined Right with Left Formula problems
    By jj72uk in forum Excel General
    Replies: 4
    Last Post: 03-19-2010, 11:32 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