Problem with VLOOKUP (doesn't see it as a formula)

[Oxana_Edelman]

Hi,

Please, help me with my Excel (MS 365). 

I try to use the VLOOKUP formula and Excel doesn't see it as a formula (I checked the format and have already tried to resolve this issue with the MS tech support, but we couldn't manage it.

I can provide access to demonstrate the problem.

Thank you very much in advance.

[#2 · Accepted solution]

@Oxana_Edelman 

If you work with english version of Excel you have to use "," instead of ";".

For example:

=VLOOKUP(E3,$B$2:$C$12,2,FALSE)