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.

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.