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?
Bookmarks