Need help to look values of the respective sku in different column

  • Hi there,



    I am in puzzle. I have several sku with same header and values but they are located in different column horizontally. See image1.jpg. Now I have manually arrange them like same header in one column below their respective values. see image3.jpg.



    I think macro will not work. May be some look up formula will work. I will create table sky and header like "image2.jpg" and some lookup function look the values in image1.jpg table and filled in blank header column.



    Please let me know if this possible. OR do you have different idea for it. Manually create so much pain in my brain.



    Regards,
    Jame
    IMAGE1
    A: column header
    B: values
    C: part number


    http://i1294.photobucket.com/a…ge/image1_zps23fa7ad0.jpg



    image2


    http://i1294.photobucket.com/a…ge/image2_zps84bd99ee.jpg



    image3


    http://i1294.photobucket.com/a…ge/image3_zps9fbe1146.jpg

  • Re: Need help to look values of the respective sku in different column


    Trying to understand "create pain in my brain"


    My apologies if English is not primary language!

  • Re: Need help to look values of the respective sku in different column


    Put Headers in a new sheet (row 1) and run this (adjust Sheet reference to suit)



    Workbook attached to show working.

  • Re: Need help to look values of the respective sku in different column


    JohnCleary


    Thanks for picking up on the crossposting.


    michellejames


    If you are going to post the same question on more than one forum you MUST include a link to all other postings with your question. This saves people wasting their time working on a solution for you when the question has been answered elsewhere. You did agree to do so when you agreed to abide by Ozgrid's rues when you first registered!


    If my solution works for you please edit your post on MrExcel with a link to this thread and mention problem solved.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: Need help to look values of the respective sku in different column


    Thanks johncleary.... Seems like you are the new world police, for excel forums at least :)


    michellejames --- you MUST state if you have posted your question in other forums. This is part of the rules you agreed to when you signed up. It prevents people from answering a question that might already be answered elsewhere.



    Regards,
    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

  • Re: Need help to look values of the respective sku in different column


    Hi KjBox ,



    Greeting! Thanks for the code. It working fine. Yes, i have post my query two forum due to no one give answer in that forum. Sorry for delay replying due to out of office. I have change the header and try. It working excellent.



    I want to scrapped the large images from amazon product page. but unable to scrapped due to java script code. Can we extract the large images or large image url of every swatch color like black, red...etc? As you see the they are in roll over image function? The page is full java script.

    http://www.mrexcel.com/forum/e…rge-image-url-amazon.html



    http://www.amazon.com/dp/B002O5I2JA/ref=twister_B000BJR2WE


    Regards,
    James

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!