How do I use VLOOKUP with multiple sheet?

Occasional Visitor

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