+ Reply to Thread
Results 1 to 5 of 5

Excel Match and Grab Formula Help

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    47

    Excel Match and Grab Formula Help

    I need some help with a formula, but I have no idea how to create it or what to use. Basically I have 3 columns of data, one is a list of SKUs (Column 1), another is a list of SKUs (Column 2), and the last is a list of prices (column 3).

    Column 1 is by itself, and it represents items sold, so the same SKU can appear in column 1 more than once. Column 2 and 3 represent the SKU and it's cost respectively.

    I would like to create a formula in a fourth column. It would be something like this: Take the value in column 1 and find that same value in column 2. Once the same value is found in column 2, give me the value to immediate right of column 2 in column 3.

    I have created an example table with Column 4 representing the result I would like to have show.

    Here is an example of how I would like to have it work (Looks at the table for refernce):

    C1R1 is 5183. That matches with C2R2, and in C4R1 I would like the value from C3R2.
    C1R2 is 4900. That matches with C2R5, and in C4R2 I would like the value from C3R5.
    And so on and so on...


    Column 1 Column 2 Column 3 Column 4 (Result)
    Row 1 5183 720 4.03 9.87
    Row 2 4900 5183 9.87 2.88
    Row 3 710 5184 7.82 0.87
    Row 4 710 5185 2.88
    Row 5 720 4900 2.88
    Row 6 4235 5190 0.27
    Row 7 4275 5195 0.34
    Row 8 4285 710 0.89
    Row 9 4295 4235 1.45

    Please let me know if I need to clarify anything.
    Last edited by johnlynches; 01-12-2012 at 08:48 PM. Reason: Table needed HTML'd

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Excel Match and Grab Formula Help

    Hello John, welcome to the forum.

    try to use VLOOKUP. D1 then cpy down.

    =VLOOKUP(A1,B:C,2,0)
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    01-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Excel Match and Grab Formula Help

    WOW! Thanks a bunch for the help, you literally just saved me hours of work.

    I just have one more question, do you know how I would make that formula link to another sheet in excel? A1 would be in the same sheet, but the B:C part would be in Sheet2 for example. My professor in college always told us it was possible, but wouldn't tell us unless we took her advanced class.

  4. #4
    Registered User
    Join Date
    01-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    47

    Re: Excel Match and Grab Formula Help

    Nvm, just googled it. Thanks for the help Haseeb, I really appreciate it.

  5. #5
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Excel Match and Grab Formula Help

    Glad to hear John. if you are satisfied with solution please mark your thread as SOLVED.

    To mark your thread solved do the following:
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

+ 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