Vlookup other sheet

[Ulla_Zeeberg]

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

[#2]

@Ulla_Zeeberg 

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)

[#3]

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

kind regards, Ulla

[#4 · Accepted solution]

@Ulla_Zeeberg 

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)

[#5]

Waouw - that worked! Thank you so very much:)