How do I make a vlookup return a range name in an array table? I have a spreadsheet with several ranges that holds budgeting and forecasting data but only a single graph. The idea is to select a particular product from a drop down combo box and the graph displays only that product. To this end I have an array formula:
{=index(data_area,e62,0)}
which works well if the data is all contiguous.
Where I am striking trouble is when I try to use a vlookup instead of "data_array" to return a range name but I get returned the dreaded #Value, I know there should be a simple answer but can't seem to see it. Any help would be much appreciated.
{=index(data_area,e62,0)}
which works well if the data is all contiguous.
Where I am striking trouble is when I try to use a vlookup instead of "data_array" to return a range name but I get returned the dreaded #Value, I know there should be a simple answer but can't seem to see it. Any help would be much appreciated.