- Posts: 367
- Thank you received: 18
×
WooPrice Calculator PRO
[SOLVED]Vlookup with match does not work
- Enrico
-
- Offline
Less
More
1 year 9 months ago - 1 year 9 months 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
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: 1 year 9 months ago by Enrico.
Please Log in or Create an account to join the conversation.
- Cody Kremers
-
Topic Author
- Offline
Less
More
- Posts: 3
- Thank you received: 0
1 year 10 months ago - 1 year 10 months 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.
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: 1 year 10 months ago by Cody Kremers. Reason: info correction
Please Log in or Create an account to join the conversation.
- Cody Kremers
-
Topic Author
- Offline
Less
More
- Posts: 3
- Thank you received: 0
1 year 10 months 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?
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.
- Enrico
-
- Offline
Less
More
- Posts: 367
- Thank you received: 18
1 year 10 months 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
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
Please Log in or Create an account to join the conversation.
- Cody Kremers
-
Topic Author
- Offline
Less
More
- Posts: 3
- Thank you received: 0
1 year 10 months 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?
I tried just a simple vlookup and it worked - is it perhaps the MATCH that is causing this to break in the plugin?
Please Log in or Create an account to join the conversation.
Moderators: david
Time to create page: 0.162 seconds