+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 22

How to devive same word when few characters in 2 words are different.

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    How to devive same word when few characters in 2 words are different.

    Dear Friends,

    PFA

    1. In col U, when I give the formula, it sometimes it shows "#N/a".
    Is there any formula which gives the output mentioned in col V.?

    2. Is there any formula which give the output mentioned in col W?

    Please assist.

    I need to reconcile huge database. Manually exercise is very time consuming.

    Please assist.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-19-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    188

    re: How to devive same word when few characters in 2 words are different.

    To answer your first question, try:

    =IFERROR(IFERROR(VLOOKUP(T2,$B$11:$C$14,2,0),VLOOKUP(T2,$B$2:$C$4,2,0)),"")

    To answer your second question, try:

    =IFERROR(IFERROR(VLOOKUP(T2,$B$11:$D$14,3,0),VLOOKUP(T2,$B$2:$D$4,3,0)),"")

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,946

    re: How to devive same word when few characters in 2 words are different.

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    How to remove #N/A in formula using vlookup

    Wow...
    Thanks a lot... u made my day.
    Last edited by lalaarif1; 10-12-2018 at 12:20 AM.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,946

    re: How to devive same word when few characters in 2 words are different.

    Your post does not comply with Rule 6 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

    If you are unclear about the request or instruction then send a private message to them asking for clarification.

    All participants:
    Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

  6. #6
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    How to devive same word when few characters in 2 words are different.

    Dear Friends.

    This is in continuation of my previous post. I apologise for my previous post's title.

    PFA

    Is there any way where we can derive output mentioned in W5, W6.

    Formula in cells W2:W4 is give by the forum. But it fails in W5, W6.

    I need to reconcile huge database and manually doing the task is very time consuming and there are chances of making errors also.

    Please assist.
    Attached Files Attached Files
    Last edited by lalaarif1; 10-12-2018 at 01:56 AM. Reason: Title was wrong

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,946

    Re: How to devive same word when few characters in 2 words are different.

    lalaarif1 you will get no further help until you comply with my request to show a link to other sites you posted this on. I know of at least 1 member who is waiting to assist you.

    This is not optional, and further disregard of my request could result in your privileges to this site being removed.

  8. #8
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    Re: How to devive same word when few characters in 2 words are different.

    Dear FDibbins,

    I have not posted on any other site.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,946

    Re: How to devive same word when few characters in 2 words are different.

    lalaarif1 my apologies - for 2 different reasons...
    1. I see that you had changed your title, just not on the 1st post so it would carry through - apologies for that.
    2. I indicated - in error - that you had posted on another site. I have NO idea why I claimed that, so again, my apologies

  10. #10
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,215

    Re: How to devive same word when few characters in 2 words are different.

    Please try at W2 and drag down

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    Re: How to devive same word when few characters in 2 words are different.

    Thanks a lot... Bo_Ry.

    I am very thankful to u.

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: How to devive same word when few characters in 2 words are different.

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


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  13. #13
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    Re: How to devive same word when few characters in 2 words are different.

    Bo_Ry,

    I just noticed that if I put "1067" in D3, then output in W3 is "1064" which is not correct.
    Correct output should be #N/a.

    The sequence in D2:D6 and D11:D14 will be random sequence. But your formula takes the output in first-***-first basis.

    Please assist.

  14. #14
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,215

    Re: How to devive same word when few characters in 2 words are different.

    Please give us more samples and logic on how each final bill are selected.

  15. #15
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    Re: How to devive same word when few characters in 2 words are different.

    Dear Bo_Ry,

    PFA the revised file.

    Is there any way where we can derive output mentioned in col W, X.

    Please assist since the data is huge.
    Attached Files Attached Files

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

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

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