software

Hi,

Is it possible to set the table-array in vlookup to a name referenced by
another cell?
In other words, I would like to be able to have the formula pick from a
different table dependant on a user input, where that user input is the name
of 1 of 2 possible array names.

Thus, I have a sales report where I am comparing actual to budget for each
customer. Half way through the year we will redo the budget and call it
forecast1. I want to set up one monthly report so that it reports on either
budget or forecast1 depending on whether I have quot;budgetquot; or quot;forecast1quot;
entered in cell A1, say. The formula is therefore =vlookup(a9,a1,3) where a9
will be a customer's name and 3 will be the month number. However, when I try
this it doesn't seem to work. If I replace a1 with quot;Budgetquot; or quot;Forecast1quot; it
will work.

Any help greatfully received!

Will

Use

=vlookup(a9,indirect(a1),3)

This assumes that quot;Budgetquot; and quot;Forecast1quot; are named ranges.

Regards
Phil

quot;willquot; wrote:

gt; Hi,
gt;
gt; Is it possible to set the table-array in vlookup to a name referenced by
gt; another cell?
gt; In other words, I would like to be able to have the formula pick from a
gt; different table dependant on a user input, where that user input is the name
gt; of 1 of 2 possible array names.
gt;
gt; Thus, I have a sales report where I am comparing actual to budget for each
gt; customer. Half way through the year we will redo the budget and call it
gt; forecast1. I want to set up one monthly report so that it reports on either
gt; budget or forecast1 depending on whether I have quot;budgetquot; or quot;forecast1quot;
gt; entered in cell A1, say. The formula is therefore =vlookup(a9,a1,3) where a9
gt; will be a customer's name and 3 will be the month number. However, when I try
gt; this it doesn't seem to work. If I replace a1 with quot;Budgetquot; or quot;Forecast1quot; it
gt; will work.
gt;
gt; Any help greatfully received!
gt;
gt; Will