JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,532
- Office Version
- 365
- Platform
- Windows
I have a list of products, each with a set of properties (Name, Catalog Number, Price, Weight, etc.). I would like to create an array in one sheet with all of this data and be able to access it from any other sheet in the workbook by name, rather than by cell numbers.
Suppose my product table is in Sheet1 and looks like this:
<tbody>
</tbody>
Now in Sheet2, I would like to be able to access any property of any product using labels rather than cell numbers.
For example, assuming I have a cell named "Quan", I would like to calculate the total cost of ordering Quan units of ProdB. I could use the formula:
Is there any way I can use a formula like one of the following?
Is there a way to do that?
Thanks
Suppose my product table is in Sheet1 and looks like this:
C/R | A | B | C | D |
1 | Name | CatNo | Price | Weight |
2 | ProdA | K2932 | $24.99 | 5.5 |
3 | ProdB | G16 | $14.99 | 3.1 |
4 | ProdC | MX915 | $9.99 | 2.3 |
<tbody>
</tbody>
Now in Sheet2, I would like to be able to access any property of any product using labels rather than cell numbers.
For example, assuming I have a cell named "Quan", I would like to calculate the total cost of ordering Quan units of ProdB. I could use the formula:
Code:
=Quan*Sheet1!C3
Is there any way I can use a formula like one of the following?
Code:
=Quan*Sheet1!Price!ProdB
=Quan*ProdB!Price
=Quan*ProdB.Price
=Quan*ProdB(Price)
Is there a way to do that?
Thanks