Ask the community

This is a community support forum where you can ask
questions and interact with other PremiumPress Customers.

Excel Formula Needed

  • Brandon
    Brandon
    Titan 709 points
    July 19, 2013 at 7:00 am

    Anyone know Excel good enough to provide a formula.

    I have 4,000 products to Import with my CSV file but need to get a formula set up to search my Excel file and automatically enter the pricing so I can copy pricing over to my CSV file to Import.

  • Richard Bonk
    Richard Bonk
    Super Guru 2,739 points
    July 19, 2013 at 7:46 am

    If you explain how you want your prices calculated, I will help you.

    Kind regards,

    Richard
    _____________________________________________________________________
    Wide range of PremiumPress and WordPress Plugins and add-ons
    PremiumPress customisation services and Website Design
    Selection of PremiumPress Child Themes

  • Brandon
    Brandon
    Titan 709 points
    July 19, 2013 at 7:54 am

    Richard i am sending you a email right now with my files and details.

    Title of email is Excel Formula Needed

  • Mark Fail
    Mark Fail
    Super Guru 12,821 points
    July 19, 2013 at 7:57 am

    :)

  • Brandon
    Brandon
    Titan 709 points
    July 19, 2013 at 8:22 am

    Richard can you confirm you received my email

  • Mark Fail
    Mark Fail
    Super Guru 12,821 points
    July 19, 2013 at 8:35 am

    It’s early morning UK, might take a few more hours before Richards awake.

  • Richard Bonk
    Richard Bonk
    Super Guru 2,739 points
    July 19, 2013 at 8:51 am

    @Brandon, I have replied to your email Brandon with modified spreadsheet attached. The formula to use is called VLOOKUP (http://howtovlookupinexcel.com/).

    @Mark, I usually start work at 7:00am and finish at 1:00am

    Kind regards,

    Richard

  • Mark Fail
    Mark Fail
    Super Guru 12,821 points
    July 19, 2013 at 8:58 am
    @Mark, I usually start work at 7:00am and finish at 1:00am

    :) what about the other 6 hours?

  • Richard Bonk
    Richard Bonk
    Super Guru 2,739 points
    July 19, 2013 at 9:11 am

    what about the other 6 hours?

    This is time when I can relax and do some website customisations. ๐Ÿ˜›

  • Kiran
    Kiran
    Elite Member 434 points
    July 19, 2013 at 9:22 am

    ๐Ÿ˜›

  • Mark Fail
    Mark Fail
    Super Guru 12,821 points
    July 19, 2013 at 9:40 am

    :)

  • Brandon
    Brandon
    Titan 709 points
    July 19, 2013 at 2:31 pm

    Richard you are AWESOME.

    I want to thank you so much for the amount of time this Formula will save me.

  • Mark Fail
    Mark Fail
    Super Guru 12,821 points
    July 19, 2013 at 2:37 pm

    thanks for letting us know Brandon

  • Brandon
    Brandon
    Titan 709 points
    July 19, 2013 at 2:41 pm

    Richard, I noticed something that I need to ask how to do with this new Revised file you created.

    How can I copy the Retail prices from the Excel file you created to my CSV import file.

    I just tried to copy the Retail prices and it is looking for the formula.

    it shows #REF! when I paste the price into the CSV file

  • Brandon
    Brandon
    Titan 709 points
    July 19, 2013 at 2:43 pm

    I think I just figured it out.

    It looks like I need to Paste it as PASTE SPECIAL and then select Values.

    This seems to work.

Viewing 15 posts - 1 through 15 (of 16 total)