SOLVED

# Vlookup other sheet

Copper 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

4 Replies

# Re: Vlookup other sheet

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)``

# Re: Vlookup other sheet

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)
Solution

# Re: Vlookup other sheet

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)``

# Re: Vlookup other sheet

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