+ Reply to Thread
Results 1 to 8 of 8

Compare sheet1 and sheet 2 and display the output

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    173

    Compare sheet1 and sheet 2 and display the output

    There is 2sheets of excel, in sheet1 it has borrower id and product type column, here I want to compare product type with borrower id (unique)and change product type as per sheet1
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,553

    Re: Compare sheet1 and sheet 2 and display the output

    What is the expected answer for 908010915??

    If it is a blank (908010915 is not on sheet 1), then try:

    =IFERROR(INDEX(Sheet1!O:O,MATCH(Sheet2!B2,Sheet1!B:B,0)),"")

    in O2 of sheet 2.
    Attached Files Attached Files
    Glenn



  3. #3
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    173

    Re: Compare sheet1 and sheet 2 and display the output

    908010915
    908011307
    908013311
    908013601 it want to remain the same whatever it exists already in sheet2 but it shows blank, pls do the change in formula and send again

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,553
    Quote Originally Posted by maddyrafi1987 View Post
    908010915
    908011307
    908013311
    908013601 it want to remain the same whatever it exists already in sheet2 but it shows blank, pls do the change in formula and send again
    So... what is your expected answer, as requested?

  5. #5
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    173

    Re: Compare sheet1 and sheet 2 and display the output

    my expected answer is, in sheet1 this id not available means then in sheet2 it want to remain the same like,
    908010915 sanitation
    908011307 water
    908013311 Water Filter
    908013601 sanitation

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,553

    Re: Compare sheet1 and sheet 2 and display the output

    OK. You cannot get Excel to "remember" a value in that way. If the ID number is not present, it can ONLY return a blank. To do what you want, you will need VBA. Is that OK? I cannot help you (no good with VBA), but I can move it to the VBA sub-forum where someone else will help. Let me know...

  7. #7
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    173

    Re: Compare sheet1 and sheet 2 and display the output

    no, i need in excel only

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    21,553

    Re: Compare sheet1 and sheet 2 and display the output

    Then you cannot do it.

+ Reply to Thread

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