How to insert a user-selected value into an INDIRECT(ADDRESS formula?!?!
Posted by Dustin on March 21, 2001 1:06 PM
Good afternon all,
How should I go about writing a formula to insert a user-selected value (chosen from a drop-down list) into a formula to look up a value in a different workbook?
The value to be selected is the name of a particular office (which also corresponds to the name of the tabs in the source workbook) for our company.
I have a working version of the formula provided I actually insert the office name into the formula, but in order to save tons of time, I need to determine how to use a cell reference to use whatever name is selected by the user into the formula so that I can return the value from the correct worksheet in the source workbook.
Thanks in advance.