# Help with Tab Names in Formulas

#### sir_william

##### New Member
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.

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?

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### Norie

##### Well-known Member
Have you looked at the INDIRECT worksheet function?

#### Scott Huish

##### MrExcel MVP
Perhaps:

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

#### sir_william

##### New Member
Hotpepper,

I tried it, and it worked perfectly!

Thanks a million, and thanks for the quick reply!

Replies
2
Views
120
Replies
4
Views
149
Replies
1
Views
48
Replies
5
Views
141
Replies
5
Views
210

1,182,042
Messages
5,933,377
Members
436,891
Latest member
DanDan

### 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.

### Which adblocker are you using?

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

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