Hi,
I'd like to know how to use the indirect, address and match functions to display a value based of two variables, region and quarter. For example, if I select Global and QTR 1 from a dropdown list, I'd like to dispaly / pull the appropriate data from a table array and insert to a specific cell. I have attached a sample file for illustration purposes.
I have Excel 2007.
Thanks!
Bookmarks