Forum Discussion
monicafischermoni
Jan 12, 2022Copper Contributor
How do I use VLOOKUP with multiple sheet?
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
Sort By
- SergeiBaklanDiamond Contributor