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