Results 1 to 5 of 5

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

Threaded View

  1. #1
    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.

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