[SOLVED]VLOOKUP with colun parameters do no work in wooprice

Home – SaaS Forums Support questions WooPrice Calculator (Pro) [SOLVED]VLOOKUP with colun parameters do no work in wooprice

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #5239
    matthieuh
    Participant


    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.

    #5241
    bill
    Participant

    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

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.