+ Reply to Thread
Results 1 to 8 of 8

comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to sheet 1

  1. #1
    Registered User
    Join Date
    09-17-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    6

    comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to sheet 1

    Hey Guys,

    is this possible ??


    I am trying to compare two columns Sheet1 A and Sheet2 B. if the values match, take the value from Sheet2 D and insert it in Sheet1 A.

    I am not good at excel at all so not sure where to begin.

    any help is appreciated!

    Thanks,
    Sam
    Attached Files Attached Files
    Last edited by samvivi7; 05-15-2018 at 08:53 AM.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to shee

    It sounds like a lookup formula (such as VLOOKUP or INDEX MATCH) is what you are looking for here.

    Attach a sample workbook.

    Make sure there is just enough data to demonstrate your need

    Make sure your desired results are shown, mock them up manually if necessary.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  3. #3
    Registered User
    Join Date
    09-17-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    6

    Re: comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to shee

    Quote Originally Posted by 63falcondude View Post
    It sounds like a lookup formula (such as VLOOKUP or INDEX MATCH) is what you are looking for here.

    Attach a sample workbook.

    Make sure there is just enough data to demonstrate your need

    Make sure your desired results are shown, mock them up manually if necessary.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"
    so I uploaded my file and highlighted is what I am looking for. I hope I am making sense.

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to shee

    Try this in D3:

    =IFERROR(INDEX(Sheet2!B:B,MATCH(A3,Sheet2!D:D,0))&"","")

    The blanks mean that there was no match or the corresponding result was blank.

  5. #5
    Registered User
    Join Date
    09-17-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    6

    Re: comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to shee

    Quote Originally Posted by 63falcondude View Post
    Try this in D3:

    =IFERROR(INDEX(Sheet2!B:B,MATCH(A3,Sheet2!D:D,0))&"","")

    The blanks mean that there was no match or the corresponding result was blank.
    It worked in the sense that it brought over the values from Sheet2 but randomly. I have ' a leading (apostrophe) before my values in Sheet2. does it have anything to do with it??

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to shee

    I'm not sure why you think it is random. The formula gave the same results as you highlighted in yellow.

    All that you have to do is copy the formula from post #4 and paste it into Sheet1 D3 of your sample workbook that you shared in post #1. Then drag the formula down column D.

    After doing this, you will see that D3 is blank, D4 is -G7, D5 is -7CPU1, etc.

  7. #7
    Registered User
    Join Date
    09-17-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    6

    Re: comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to shee

    Quote Originally Posted by 63falcondude View Post
    I'm not sure why you think it is random. The formula gave the same results as you highlighted in yellow.

    All that you have to do is copy the formula from post #4 and paste it into Sheet1 D3 of your sample workbook that you shared in post #1. Then drag the formula down column D.

    After doing this, you will see that D3 is blank, D4 is -G7, D5 is -7CPU1, etc.
    Hey, I am so sorry, pardon my stupid ***!! when I copied the formula I didn't pay attention to the row number. just corrected it and everything works perfectly!! thank you so much !!!!! you saved me hours thank you again

  8. #8
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: comparing two columns in sheet 1 A and sheet2 B. if true add value of sheet2 D to shee

    You're welcome. Happy to help.

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

+ 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] macro to copy sheet 1 to sheet2 start at row 16 and paste sheet 2
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2017, 05:58 AM
  2. [SOLVED] Reference sheet (sheet1) keeps changing when adding a new row on data sheet (sheet2)
    By rhett7660 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2016, 01:20 PM
  3. Replies: 3
    Last Post: 09-24-2015, 08:20 AM
  4. Autofilter, copy from sheet 1 and paste to sheet2, delete previous info on sheet 2
    By leigh12483 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2015, 08:21 PM
  5. Copy/paste row with todays date in Sheet2 to sheet 3....but from Sheet 1
    By cammyjane10 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-25-2013, 01:07 PM
  6. Replies: 4
    Last Post: 09-04-2012, 03:23 PM
  7. How to Link Sheet2 Rows to Sheet 1 Columns???
    By kimmyhendrix in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-13-2010, 02:45 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