Thread: Reference the same cell based on tab name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Reference the same cell based on tab name
Hi,

Am Thu, 29 May 2014 06:23:10 -0700 (PDT) schrieb
:

I have a worksheet listing all of our locations. On a summary tab, I want to pull a certain cell number based on the tab name but I can't figure out how to change the reference so that I can fill based on tab name. Column A has all of our branch numbers that correlate with the tabs. I want to pull out cell B17 from each of those tabs. Any ideas? Thanks!

in B1 of Summary:
=INDIRECT("'"&A1&"'!B17")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote