Dragging vlookup across columns

Erin G

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.

Paul Newcome

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.

Paul Newcome

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.

Erin G

Brilliant - thank you!

Erin