Search results

Narayan, I did try what you said and it didn't work. I checked this with another excel power user in my company who hadn't used hyperlinks in this way but understood your directions and she ended up getting the same result with my production file and mockup as I did. I want to thank you for...

Additionally, I didn't get a cell reference result for checking the constituent result of the address/match formula so I just plugge a cell reference in the test for step 3.

1. In mock up file =MATCH('2015 Forecast'!A67, 'Rollforward by Product '!$A:$A, 0) yields 2 in production file =MATCH('2015 Forecast'!A67, 'Rollforward by Product '!$A:$A, 0) yields see screen shot and cell reads as #N/A 2. mockup up file =ADDRESS(MATCH('2015 Forecast'!A67...

Narayan, Thanks for responding. I can't share my file as it is customer sensitive. My plan was to do a mock of my file and share that with you but the formula works in my mockup file. I have tried various tests to determine why it works in my mock file but not in my production file. The...

I am looking to create a dynamic hyperlink to navigate to cell based on value rather than a specific cell address. Here is my scenario: Workbook “Client Renewal Forecast” sheet “2015 Forecast” cell A67 = client name Sheet “'Rollforward by Product” is pivot table where somewhere in range A:A...

I am trying to do a variance analysis between pivot tables in a local file and pivot tables in a file posted to sharepoint. I would like to link to sharepoint file and create a linked copy of the pivot tables to the network file so I only ever have to open the one file for refreshing and...