How do I use VLOOKUP with multiple sheet?

Copper Contributor

I want to know how to make a vlookup from sheet 1 to sheep 7 using column A to column I (in all of the sheets).

 

All I got is:

 

=vlookup(A2, 'Sheet1:Sheet7'!A:I, 7,0)

 

But I  got an error. How do I fix the range between columns and sheets?

1 Reply