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
Check out the Formula Handbook template!