Dragging vlookup across columns
Hi there,
I'm trying to pull a whole line of info from one sheet to another (same data different use case) using VLOOKUP. It's a perpetual need so copy/paste is not sufficient.
=VLOOKUP("System Total", {Calculated count Range 1}, 7, false)
The formula is fine but I am currently having to manually update column_num every time I move this into a new column. I would like to be able to drag the formula across columns and have column_num move with me, so first column looks up column 7, next looks up 8, etc.
Does anyone know if this is possible in Smartsheet?
Thanks,
Erin
***SIDE NOTE: After playing around a bit, I am probably just going to use Cell Link for this situation. Still curious if you can drag a vlookup though.
Best Answer
-
You would have to use a "helper row" where you have the column number entered and then reference this row in the column number portion of the VLOOKUP.
Answers
-
You would have to use a "helper row" where you have the column number entered and then reference this row in the column number portion of the VLOOKUP.
-
Brilliant - thank you!
Erin
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!