cell reference

Is it possible to connect a cell value to another one?

Example: I have a dtabase of items with their item number price detail etc.

I want to connect the item number with its price so that when I enter for example #00652 in a formula, or click on a cell containing #00652 in a different worksheet the fromula will recognize it for example as $189.99

Thank you!!

By: jennifer

Leave a Reply

Your email address will not be published. Required fields are marked *