Do you work with MS Excel a lot? Do you use multiple sheets inside the same workbook?

If so, have you ever found yourself trying to reference a value from a worksheet other than the one you're currently working with?

I bet you noticed a problem when you tried the same old formula, am I right? For example, if you need online purchase viagra the value from cell B2 from sheet 1 in a formula on sheet 3 and used =B2 as your formula, you were in for a surprise. You got the value from cell B2, but unfortunately, it was from worksheet 3, not worksheet 1. What a nightmare!

Looking for the "magic" you must add to your formulas to get Excel to behave the way you'd like?

Was that a big yes I heard? I knew it!

Here's the trick: unless you tell Excel to look on a different worksheet, it's going to pull numbers from the sheet that contains the formula. So, you need to tell Excel exactly where to go (that is, tell it where to find your data). You'll need to add the sheet name to your formula so that Excel knows which sheet to look on for your value.

Continuing with the example from above, if you want to pull a value located in cell B2 on sheet 1, you would enter in this formula:

=Sheet1!B2

Yep, that's it! You simply have to add the sheet name (with the !) before the cell address and you've instantly got the value you really wanted.

Even more, the value will automatically update as you change the original data in cell B2 on worksheet 1. How great is that? Give it a try today!