Single cell table array VLOOKUP

[williack]

I am just wondering if its possible to use a single cell as the reference for the table array argument in VLOOKUP? This single cell would be on the same worksheet as my VLOOKUP formulas, and would contain the information on the table array (from a different workbook) to use.

Is this possible?

Example: my VLOOKUP formula might look like this VLOOKUP(B9,Sheet1!$A$4:$M$50,4,FALSE) I would like to replace the "Sheet!A$4:M$50" with a single cell reference.

Thanks!

 

[Matty]

Welcome to the Board...

Why would you want to do such a thing? If you simply want the value in a specific Cell, why not just reference that single Cell instead of using VLOOKUP?

I suspect the thing you're trying to do is more complex than your post suggests though. Could you elaborate further as to what you're trying to do?

Matty

 

[williack]

Thank you for your quick response!

Right now my table array has 216 different IDs. For the sake of my data arrangement, these need to be categorized into 18 different groups (1 worksheet for each group). I thought it would be best to create a single excel template, where I could simply change the ID numbers in each worksheet.

I thought it would be easiest to have a single cell in the template that would already contain the table array information. That is A1 would be my table array, and my VLOOKUP would read (A2,A1,4,FALSE) for example.
Then, when I open up my template, all I have to change is A2.

Does that make sense?

Is there anyway at all to put all the information of a table array into one cell?

 

[Matty]

Are you aware of Named Ranges?

I think this is what you need based on your last post. Try this link to find out more on Named Ranges:

http://www.contextures.com/tiptech.html

Post back if you need further help.

Matty

 

[williack]

Thank you! I will go check that out.