I have a list of products with corresponding prices in the second column. I have tried to figure out how to accomplish what I need on my own... keep hitting that brick wall, and yes I have the headache that goes with it...
What I want is on one sheet of a calculator I have created to have a cell where you can insert a product number. When that product number is inserted the next cell over needs to pull from thwat product number look it up in the catalog and insert the price in said cell...
Can this be done, am I asking too much?
And can I also autopopulate the watts for said product when a product number has been entered?
What I want is on one sheet of a calculator I have created to have a cell where you can insert a product number. When that product number is inserted the next cell over needs to pull from thwat product number look it up in the catalog and insert the price in said cell...
Can this be done, am I asking too much?
And can I also autopopulate the watts for said product when a product number has been entered?
