Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
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 "budget" or "forecast1" 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 "Budget" or "Forecast1" it will work. Any help greatfully received! Will |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup
Use
=vlookup(a9,indirect(a1),3) This assumes that "Budget" and "Forecast1" are named ranges. Regards Phil "will" wrote: 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 "budget" or "forecast1" 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 "Budget" or "Forecast1" it will work. Any help greatfully received! Will |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |