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 colun parameters do no work in wooprice

More
10 months 1 week 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
10 months 1 week 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.143 seconds

Notice: Customizations are temporarily suspended

Cart

Total : 0.00 €