Forum Discussion
Ulla_Zeeberg
Jan 21, 2023Copper Contributor
Vlookup other sheet
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
Do 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)
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)
- Ulla_ZeebergCopper ContributorThanks for the answer. I tried to copy-paste your line into the sheet, but it still doesn't work unfortunately,
kind regards, UllaDo 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)