Using a value in a cell as a range name in a formula

Hi,

I'm trying to use a vlookup function where the lookup_table value is named range in another sheet. Let's call it {Range 1}.

If I type {Range 1} into the formula, it works just fine. But I want to be able to use a string from another cell to populate that information in the formula. For example, the column "Table" in my sheet contains the string {Range 1}. I want to be able to do =vlookup(search_value, Table@row, column_num, [match_type]) to lookup the value. So rather than typing in the value for the lookup_table, I want to get it from a cell value in my worksheet.

I've tried making the value in the cell {Range 1}. I've tried in the formula using "{"+Table@row+"}". But neither works. Again, it works fine if I type in the value {Range 1} in the formula.

Any suggestions?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for reference?

mzelk

Paul Newcome

It isn't possible to do exactly what you are wanting to do, but there may be a work around. Are you able to provide more detail on exactly why you are wanting to do this? Are all of the tables on the same sheet or different sheets? What determines which table to pull from?

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.