Pulling Data from Sheet 1 to Sheet 2 using VLOOKUP

Krishna Patel · 01/23/20

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!

Alejandra · 01/25/20

Hello @Krishna Patel,

The column_num position of the VLOOKUP function is a placeholder for a number representing the column position (in lookup_table "Sheet1") of the value to return, with the leftmost column of lookup_table at position 1.

Instead of referencing back to "Sheet1" you'll want to enter the number of the column containing the return value.

Here's an example of what your formula could look like: =VLOOKUP("Look Up Value", {Sheet1 Range 6}, 2, false)

If needed, more information on VLOOKUP can be found here: https://help.smartsheet.com/function/vlookup

Alejandra · 01/25/20

Hello @Krishna Patel,

The column_num position of the VLOOKUP function is a placeholder for a number representing the column position (in lookup_table "Sheet1") of the value to return, with the leftmost column of lookup_table at position 1.

Instead of referencing back to "Sheet1" you'll want to enter the number of the column containing the return value.

Here's an example of what your formula could look like: =VLOOKUP("Look Up Value", {Sheet1 Range 6}, 2, false)

If needed, more information on VLOOKUP can be found here: https://help.smartsheet.com/function/vlookup

Krishna Patel · 01/27/20

Thank you for the information. I finally figured it out late Friday.

Pulling Data from Sheet 1 to Sheet 2 using VLOOKUP

Best Answer

Answers

Help Article Resources

Categories