Brandon

Excel Formula Needed

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.

Created: July 19, 2013 at 7:00 am
  • In: General Discussion
  • Started by: BrandonBrandon
  • 4 members left 15 comments
  • Last reply from: Mark FailMark Fail

  • Richard Bonk
    Richard Bonk
    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
    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
    July 19, 2013 at 7:57 am

    🙂

  • Brandon
    Brandon
    July 19, 2013 at 8:22 am

    Richard can you confirm you received my email

  • Mark Fail
    Mark Fail
    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
    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 ().

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

    Kind regards,

    Richard

  • Mark Fail
    Mark Fail
    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
    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
    July 19, 2013 at 9:22 am

    😛

  • Mark Fail
    Mark Fail
    July 19, 2013 at 9:40 am

    🙂

  • Brandon
    Brandon
    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
    July 19, 2013 at 2:37 pm

    thanks for letting us know Brandon

  • Brandon
    Brandon
    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
    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)