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
-
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
Answers
-
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
-
Thank you for the information. I finally figured it out late Friday.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!