Vlookup other sheet

Copper Contributor


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

4 Replies


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)



Thanks for the answer. I tried to copy-paste your line into the sheet, but it still doesn't work unfortunately,

kind regards, Ulla
best response confirmed by Ulla_Zeeberg (Copper Contributor)


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)
Waouw - that worked! Thank you so very much:)