Jan 21 2023 06:23 AM
Hi
I am having problems with a quite simple VLOOKUP:
The formula goes:
=VLOOKUP(A2,'Englands tur’!$A$2:$G$41,7,0)
I want to retrieve the number in the sheet called 'Englands tur' in column G, where the lookup-key is the A column in both sheets
Can anyone help me see what goes wrong?
When i press enter, it highlights the part A2, 'Englands
Jan 21 2023 07:28 AM - edited Jan 21 2023 07:29 AM
The single quote after Englands tur is a "curly quote". Replace it with a straight single quote:
=VLOOKUP(A2,'Englands tur'!$A$2:$G$41,7,0)
Jan 21 2023 07:40 AM
Jan 21 2023 07:47 AM
SolutionDo you use comma as decimal separator? If so, you should use semicolon to separate the arguments of the function:
=VLOOKUP(A2;'Englands tur'!$A$2:$G$41;7;0)