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

VLOOKUP with colun parameters do no work in wooprice

More
2 months 3 weeks ago #2050 by bill
bill replied the topic: VLOOKUP with colun parameters do no work in wooprice
Hi Matthieu ,

a VLOOKUP formula in WPC can't have a range as first parameter and an unlimited range in the second one.
For the second parameter you need to specify a number , but this can be solved inserting a large number like 5000, and at the end will be something like:

VLOOKUP(A1;M1:Z5000;2;0)

I took A1 as an example but it can be any cell you prefer.

Best regards.
Bill
AT1043

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

More
2 months 3 weeks ago #2047 by matthieuh
matthieuh created the topic: VLOOKUP with colun parameters do no work in wooprice
-
Writing an excel formula as follow do not work in wooprice (but work in excel)

VLOOKUP(A:A;M:Z;2;false)
Where A:A is the column with pointer, M:Z is the table where applying Vlookup.

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

Moderators: david
Time to create page: 0.148 seconds

Cart

Total : 0.00 €