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?