Referencing an equation using vlookup/array

[mc_day]

OK let me try to be clear in describing what I am interested in getting

I have a worksheet that contains a list of equations (written out) that are linked to a particular object.

ex. ACRU ((2.7182818^5.32)*(DBH^2.17))/1000
BEPA ((2.7182818^4.86)*(DBH^2.33))/1000

so that ACRU relates to ((2.7182818^5.32)*(DBH^2.17))/1000

I would like to be able to lookup and calculate the following equation in another worksheet when ever I come across ACRU?

 

[pgc01]

Hi
Welcome to the board

You can define ACRU as a named formula

Define->Name

Name: ACRU

Refers to: =((2.7182818^5.32)*(DBH^2.17))/1000

 

[mc_day]

So I have
ACRU and I want to link it to

((2.7182818^4.86)*(DBH^2.33))/1000

So in one column I have a list and in a corresponding column I have equations that are associated with the original list

I don't just want to define/name the information I actually want to calculate the new value using the listed equation