Selecting Worksheets by numerical or text value in cell
I am not an Excel fundy! What is the formulation if I want to use a continuously variable numerical or text value of a cell to select the correct worksheet in which I want to lookup and return a value reflected in a named column/table of that selected worksheet? (All in the same workbook).
I attached a word document (to explain the logic) and the excell spreadsheet (for the formulas) so that you can play around with. Can you please help me to get it going?
Last edited by Steyn; 05-05-2011 at 05:22 AM.
Reason: Heading not fully displayed
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1