Ok, the specific context of how this would be useful:
I have a table with information about a product. The product uses a
formula to determine its price. That formula uses statistics based on
location. On another sheet, I have all of the information from one
location, and on a third sheet, I have all of the information for a
second location. Now, I have a drop-down list where the user can select
the product. Then, using VLOOKUPs, I populate all of the product
information into the location sheet. Most of the products load
correctly. A few have special circumstances. The solution that I have
come up with is that on the product data sheet, I would like to use a
formula that will update based on the current active sheet. The problem
is that, once I select one of the location sheets, the product data
sheet does not update with the new active sheet. Is there some way to
force the cells on the product sheet to update when either of my two
location sheets become activated? This would allow the formula in one
cell to display different information depending on which location is
active.

NickHK wrote:
I don't understand your logic:

B1 says '=A1'
C1 says '=A1'

But B1<C1 ??

NickHK

"shai-hulud" wrote in message
ups.com...
Hello,

Is it possible to create a formula that will display different results
depending on which cell links to it?

For instance, cell A1 contains a formula.
Cell B1 says '=A1'
Cell C1 says '=A1'
The formula in cell A1 changes the results depending on whether it is
being displayed in cell B1 or C1, so all three cells have different
results.

Is that possible?

Very Respectfully,
Neil