Vlookup problem

[Bandito1]

Hi all,

Im trying to retrieve data with Vlookup;

=VLOOKUP(F18;A11:C12;2;FALSE)

In F18 i typed "January".

It doesn't find any data; the months in Column A are made with;

=DATE($A$9;ROWS($9:9);1)

When i type there "January" it works.

I can't hard type "January" cause than other data will not be retrieved.
Anyone know how i can retrieve data with Vlookup based on month if i use a formula to created the month?

Tracker QA on the floor New.xlsm
	A	B	C
11	January	133	122
12	February	74	70
BMR data

Cell Formulas
Range	Formula
A11:A12	A11	=DATE($A$9,ROWS($9:9),1)
B11:B12	B11	=SUMPRODUCT(('Tracker QA on the Floor'!J:J>=A11)*('Tracker QA on the Floor'!J:J<=EOMONTH(A11,0)))
C11:C12	C11	=SUMPRODUCT(('Tracker QA on the Floor'!L:L>=A11)*('Tracker QA on the Floor'!L:L<=EOMONTH(A11,0)))

Tracker QA on the floor New.xlsm
	F
18	January
19	#N/A
BMR data

Cell Formulas
Range	Formula
F19	F19	=VLOOKUP(F18,A11:C12,2,FALSE)

 

[James006]

What language precisely do you use ?

If you were to test the following formula =MONTH(3&"january")

What result would you get ?

 

[Bandito1]

When i type that i get #Value

How do i find out what language i use?
Sounds stupid but im located in holland and using a company pc.
This pc is based in holland but my company is US.
My excel is english (the ribbon text)

 

[James006]

If you are getting #Value with =MONTH(3&"january")

Could you test : =MAAND(1&"Januari")

 

[Fluff]

If you format a cell with a date to show the long date what do you get?

 

[James006]

Among the tests you can make ... for Dutch :

=TEXT(TODAY(),"[$-413]dddd dd mmmm yyyy")

 

[Bandito1]

=MAAND(1&"Januari") results in #NAME?

When i type 1-1-2023 in a cell and i format to long date i get: zondag 1 januari 2023 (dutch)

=TEXT(TODAY(),"[$-413]dddd dd mmmm yyyy") results in: maandag 06 maart yyyy (dutch)

 

[James006]

So ... with your current set-up Dutch language, most probably to get the number 1, you need
=Month(1&"Januari")

 

[Bandito1]

That is correct

=Month(1&"Januari") results in 1

 

[James006]

To recap, as far as functions are concerned you can work in English ...
but when it comes to Text, your Windows Regional settings do impose on you to use Dutch ...

 

[Bandito1]

So what should i change to make the Vlookup work?

Can't change the settings from the pc since it's a company pc and im not allowed to make changes to settings i guess