For Example:
In a spreadsheet whose file name is fruits.xls I have a series of worksheets with data sets for different things. One of these worksheets is called "apples" and another is called "pears." These sheets contain rows of data such as "color" and "weight."
I have another spreadsheet that I use to generate reports that I send to customers. Let's call this one "reports"
In Cell A1 of my "reports" spreadsheet I type "apples." I want cell A2 to display the color of the apples that I've recorded in cell B2 of fruits.xls "apples." That's easy. I know how to do that. However if I type "pears" in cell A1 I want cell A2 to instead call to the "pears" worksheet of fruits.xls.
Therefore if I type "apples" in A1 then A2 would fill in with B2 fruits.xls "apples" which is a value of "red." If I change the value in A1 to "pears" then A2 instead fills in with fruits.xls "pears" B2 which is "green."
Would this even be do-able with formulas?
Thanks!
Bookmarks