Pulling Data from Sheet 1 to Sheet 2 using VLOOKUP

Pulling Data from Sheet 1 to Sheet 2 using VLOOKUP

Hello,

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

Answers

Sign In or Register to comment.