[SOLVED]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

-
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.