VLOOKUP in local members

[Former Member]

Hi gurus,

I'm trying to build a Vlookup formula in a local member to get a value to a cell based in the value in a data column of a report and a grid where i have the values to select.

By i obtained the result:  #Error - Impossible to apply local member formula

My formula in the local member is: =VLOOKUP(N26;$J$15:$L$19;3;FALSE)

Where N26 is a value of the report.

Any ideas how can i solve this.

Thanks in advance.

Regards

[Former Member · Accepted solution]

Hi Jose

Try to use a comma "," in place of semicolon ";" to apply this formula in a local member or use

=EPMInsertbeforeafterblock() formula.

Best regards

Patrick

[former_member186338 · Accepted solution]

Hi,

Patrick, semicolon  is the replacement of comma in Jose's national version of Excel.

Jose, try to use INDIRECT for range

B.R. Vadim

[Former Member · Accepted solution]

Hi Vadim

Yes, i know we also have semicolon in our national version of Excel and we had the same type of error when using semicolon in local member formulas. After using comma we had solved that issue.

Best regards

Patrick

[former_member186338 · Accepted solution]

Ups, BPC 10 EPM Add In supports only English local settings (or at least local settings with "," as a delimiter)? It's a serious bug!

Vadim

[Former Member]

Replacing ";" for ", " solved the issue. Thank you very much