Hi All,

I am preparing an excel spread sheet for work and it requires that a sales consultant select a particular product from six choices and enter in a desired size in width and length. From this data i need to create a formula that will calculate the material cost of that particular product.

I have 6 tables in one sheet that will be hidden and so i wanted to know if anyone could help me create a formula that would work something like

=if(cell="category 1",index(match),if(cell="category 2",index(match),if(cell=category 3",index(match) ....... and so on

where index(match) is my formula to work out which price is returned

any help is greatly appreciated.

regards,

matt