Forum Discussion

Ulla_Zeeberg's avatar
Ulla_Zeeberg
Copper Contributor
Jan 21, 2023
Solved

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

  • HansVogelaar's avatar
    HansVogelaar
    Jan 21, 2023

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

     

     

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

      kind regards, Ulla
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        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)

Resources