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?
Answers
-
Are you able to provide some screenshots for reference?
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!