Help with Tab Names in Formulas

sir_william

New Member
Joined
Jan 19, 2005
Messages
14
Hey guys/gals. I have a problem in Denver I would like to throw out and see if any of you have any ideas. I have simplified my task for illustration of what I am trying to accomplish.

excel.jpg



What I am trying to do is create somewhat of a dynamic formula that will change the referenced tab names based on the Tab Name I specify in cells K1, and K2 respectively to compare the difference between values in the same cell for unique tabs.

My modeling for my *real example is too confusing to show, but if I could get a solution like this to work, it will greatly simplify our task or comparing a great number of tabs. Currently, I use a FIND / REPLACE in the cells to change the name of the tab in the formula to compare the results but I am convinced there is an easier way. ANy tips for doing this?

If I am not clear on my presentation please advise.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
Have you looked at the INDIRECT worksheet function?
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Perhaps:

=INDIRECT("'"&K1&"'!C4")-INDIRECT("'"&K2&"'!C4")
 

sir_william

New Member
Joined
Jan 19, 2005
Messages
14
Hotpepper,

I tried it, and it worked perfectly!

Thanks a million, and thanks for the quick reply!
 

Forum statistics

Threads
1,148,228
Messages
5,745,482
Members
423,953
Latest member
MrC54

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top