Column Formula Question

Is it possible to convert a cell formula to a column formula if it references a different sheet?

Here is the formula in question:

=VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false)

Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet. I am currently unable to convert this formula to a column formula and was wondering why?

Find more posts tagged with

Sheets

Formulas

functionality

Cell linking

Accepted answers

All comments

Jason Duryea

What are you receiving for an error message or issue indicating that it is not allowing you to convert it? You could also try using =INDEX(MATCH()) which is the recommended alternative to VLOOKUP(). It creates fewer cell references.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.