- Posts: 52
- Thank you received: 8
- Forum
- Support questions
- WooPrice Calculator (Pro)
- [SOLVED]VLOOKUP with colun parameters do no work in wooprice
×
WooPrice Calculator PRO
[SOLVED]VLOOKUP with colun parameters do no work in wooprice
- bill
-
- Offline
Less
More
1 year 11 months 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
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.
- matthieuh
-
Topic Author
- Offline
Less
More
- Posts: 23
- Thank you received: 0
1 year 11 months 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.
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
- Forum
- Support questions
- WooPrice Calculator (Pro)
- [SOLVED]VLOOKUP with colun parameters do no work in wooprice
Time to create page: 0.170 seconds