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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Find text and return address of the found cell on another worksheet (reference by cell in current worksheet)
- Thread starter rigray
- Start date
-
- Tags
- address defined name find reference
Similar threads
- Question
