Pulling Data from Sheet 1 to Sheet 2 using VLOOKUP


I have 2019 monthly data in Sheet 1 and would like for it to be populated in Sheet 2 based on current 2020 month. Basically, I want to pull same month last year data from sheet 1 to sheet 2. I've tried using VLOOKUP in sheet 2 cell but the place where I get stuck is "column_num". Column_num should be looking at a Sheet 1, Column1 but it won't work.

My formula: =VLOOKUP({Sheet1 Range 1}, {Sheet1 Range 6}, {Sheet1}1, false)

I've tried variations for column_num but nothing seems to work.

Can someone please help?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!