+ Reply to Thread
Results 1 to 5 of 5

Compare two cells, if equal move a third cells data to another cell

  1. 06-24-2013, 11:30 AM #1
    eriick
    eriick is offline
    Registered User
    Join Date
    06-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Compare two cells, if equal move a third cells data to another cell

    I have an inventory report sheet that I need to have quantities updated.

    Here is a sample of what my excel sheet looks like now.....

    Column A | Column C ......................... Column F | Column H
    (SKU) | (Blank) ......................... (SKU) | (QTY#)



    1234 | | 9374 | 6
    4383 | | 1122 | 2
    1122 | | 1234 | 1
    5567 | | 5567 | 2
    1242 | | 1242 | 0
    9374 | | 4383 | 5


    How can I get it to compare Column A with Column F ( THE SKU #)
    And if there is a match ....

    I want to copy the # from Column H into Column C for the matching SKU

    So it looks like this....

    Column A | Column C ......................... Column F | Column H
    (SKU) | (Blank) ......................... (SKU) | (QTY#)


    1234 | 1 | 9374 | 6
    4383 | 5 | 1122 | 2
    1122 | 2 | 1234 | 1
    5567 | 2 | 5567 | 2
    1242 | 0 | 1242 | 0
    9374 | 6 | 4383 | 5



    Hope this makes sense - data sheet attached.

    Thank you for any help! I really appreciatesample inv sheet.xlsx it!
    Last edited by eriick; 06-24-2013 at 11:55 AM.
    Reply With QuoteRegister To Reply
  2. 06-24-2013, 12:52 PM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Compare two cells, if equal move a third cells data to another cell

    in C30
    =VLOOKUP(A30,F$30:F$125,1,0)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 06-24-2013, 03:19 PM #3
    eriick
    eriick is offline
    Registered User
    Join Date
    06-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Compare two cells, if equal move a third cells data to another cell

    Quote Originally Posted by Special-K View Post
    in C30
    =VLOOKUP(A30,F$30:F$125,1,0)

    I tried it and get #N/A in the C30 field
    Reply With QuoteRegister To Reply
  4. 06-24-2013, 04:29 PM #4
    eriick
    eriick is offline
    Registered User
    Join Date
    06-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Compare two cells, if equal move a third cells data to another cell

    I see how this works, the C column fields get populated, but with the same value as the number in Column A - #N/A if there is no match between A & H.

    How can I have it pull the corresponding 'ON-HAND' value from the H Column into the C ?
    Reply With QuoteRegister To Reply
  5. 06-24-2013, 05:38 PM #5
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Compare two cells, if equal move a third cells data to another cell

    You may not have match on cell with error value. Add iferror function.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1