Hello everybody
I have two columns A & B with Headers : Header1 is "Products" and below this header there are data related to it ..
In Column B there is the header "Sales" and below this header there are data related to it ..
I have created a fixed named range "MyList" to include both headers .. Products and Sales
Also i have created two dynamic ranges "Products" and "Sales"
In F4 cell I have created drop down list of "MyList" and in cell F5 I put this formula
But it seems not to work with dynmaic ranges
I need UDF function that can be used in the source field that converts the dynamic range to fixed ...
Bookmarks