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!