I'm trying to do something that I thought was going to be simple; however, it's turning out to be a pain. I have 2 worksheets, sheet1 and sheet2. In sheet 1 I have a list of all of the worksheets in my book populated via a formula. In an adjacent column I want to return the address ($A$5) of week ending (right aligned) that is located on Sheet2. Here's what I'm currently trying: =VLOOKUP(Week_ending, INDIRECT("'"&A11&"'!A1"),1,FALSE). I have tried address, indirect, and a combination with no luck. Any help would be appreciated.