Total : 0.00 €

Before contacting us, please make sure to check our F.A.Q

Please, login or register to our website in order to be able to post a presale question in the forum.

× WooPrice Calculator PRO

[SOLVED]Vlookup with match does not work

More
2 months 1 week ago - 2 months 1 week ago #2258 by Enrico
Enrico replied the topic: Vlookup with match does not work
Dear Cody Kremers,

Please export your calculator following the instructions here:

altoswebsolutions.com/manual/woo-price-c...or/export-calculator

And attach it here in the forum, or if you want to send it in private to "hello@altoswebsolutions.com".

If you would like also to attach your test website credentials it will help us a lot (Please send your credentials only in private).

Kind Regards,
Enrico
AT1322
Last Edit: 2 months 1 week ago by Enrico.

Please Log in or Create an account to join the conversation.

More
2 months 2 weeks ago - 2 months 2 weeks ago #2257 by Cody Kremers
Cody Kremers replied the topic: Vlookup with match does not work
If you select 64MB and a QTY of 50 it does not calculate correctly on the excel sheet.

I also need to be able to override the default qty with the qty from the excel sheet. The article here: altoswebsolutions.com/manual/woo-price-c...write-quantity-field - does not appear to do anything nor work.

Please help.
Last Edit: 2 months 2 weeks ago by Cody Kremers. Reason: info correction

Please Log in or Create an account to join the conversation.

More
2 months 2 weeks ago #2253 by Cody Kremers
Cody Kremers replied the topic: Vlookup with match does not work
I uploaded the v2 excel you provided and reselected the fields but I am getting errors from the calculator.

www.rocketzippy.com/product/rocket-drive/

Right from page load, it gives an error. The calculations also appear to still not work. If I change the value to "100" or some other numbers it works but "50" calculates to 0.

Thoughts?

Please Log in or Create an account to join the conversation.

More
2 months 2 weeks ago #2246 by Enrico
Enrico replied the topic: Vlookup with match does not work
Dear Cody Kremers,

I've noticed a strange range in the match function, I think that was the problem.

Changing in F18, in the match function from A1 to B1 solved the problem. That's because A1 is the "Size" cell, not a number. So I think there are some unpredictable results.

Attached new Excel file and screenshot.

Kind Regards,
Enrico
AT1322
Attachments:

Please Log in or Create an account to join the conversation.

More
2 months 2 weeks ago #2238 by Cody Kremers
Cody Kremers created the topic: Vlookup with match does not work
I am using a vlookup with MATCH to get a the price per from a table. In the excel sheet it calculates correctly, however, when I upload it to select the values it does not appear to do the calculations correctly as you can see in the screenshot.

I tried just a simple vlookup and it worked - is it perhaps the MATCH that is causing this to break in the plugin?
Attachments:

Please Log in or Create an account to join the conversation.

Moderators: david
Time to create page: 0.212 seconds

Cart

Total : 0.00 €