Ok, guys, I'm truly baffled and frustrated....
My database has 30 worksheets, all consisting of team names...."ATL", "ARI", BAL, etc.
On a Master sheet, I want to reference a particular sheet via a team name, and import a specific cells data. I'm familiar with match, index and lookup functions, but none of those functions will find a worksheet, then a particular cell on that sheet. I'm told I need to use the INDIRECT function, but the syntax eludes me.
As an example: I want to match a cell containing "ATL" (found on the master), with the appropriate worksheet (in the same workbook) titled "ATL". Then import data from that sheet into a cell on the master sheet. All the teams worksheets have the data in the same place ($D$55).
For many of you guys, this may be an easy task, but any help would be greatly appreciated....