Dragging vlookup across columns

Erin G
Erin G ✭✭
edited 03/21/22 in Formulas and Functions

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?



***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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!