Forum Discussion
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, whe...
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)
Thanks for the answer. I tried to copy-paste your line into the sheet, but it still doesn't work unfortunately,
kind regards, Ulla
kind regards, Ulla
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:)