Excel Formula Needed

WordPress Business Themes Forums General Discussion Excel Formula Needed

Excel Formula Needed

July 19, 2013
Brandon Brandon
  • Brandon
    Brandon
    Titan 709 points

    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.

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

    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

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

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

    Title of email is Excel Formula Needed

    July 19, 2013 at 7:54 am
  • Mark Fail
    Mark Fail
    Super Guru 12,812 points

    :)

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

    Richard can you confirm you received my email

    July 19, 2013 at 8:22 am
  • Mark Fail
    Mark Fail
    Super Guru 12,812 points

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

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

    @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

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

    :) what about the other 6 hours?

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

    what about the other 6 hours?

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

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

    ๐Ÿ˜›

    July 19, 2013 at 9:22 am
  • Mark Fail
    Mark Fail
    Super Guru 12,812 points

    :)

    July 19, 2013 at 9:40 am
  • Brandon
    Brandon
    Titan 709 points

    Richard you are AWESOME.

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

    July 19, 2013 at 2:31 pm
  • Mark Fail
    Mark Fail
    Super Guru 12,812 points

    thanks for letting us know Brandon

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

    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

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

    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.

    July 19, 2013 at 2:43 pm
Viewing 15 posts - 1 through 15 (of 16 total)

Didn't find what you were after?

Chat with us now

or contact our support team