SOLVED

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

Occasional Visitor

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.

Oxana_Edelman_0-1663149573890.png

 

 

1 Reply
best response confirmed by Oxana_Edelman (Occasional Visitor)
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)