WordPress Business Themes › Forums › General Discussion › 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.
If you explain how you want your prices calculated, I will help you.
Wide range of PremiumPress and WordPress Plugins and add-ons
PremiumPress customisation services and Website Design
Selection of PremiumPress Child Themes
Richard i am sending you a email right now with my files and details.
Title of email is Excel Formula Needed
Richard can you confirm you received my email
It’s early morning UK, might take a few more hours before Richards awake.
@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
what about the other 6 hours?
This is time when I can relax and do some website customisations. 😛
Richard you are AWESOME.
I want to thank you so much for the amount of time this Formula will save me.
thanks for letting us know Brandon
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
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.
Submit your feature requests to our ideas board and it could be included in a future theme update.
or contact our support team