Hello,

I need help in excel to find a way to look up a value in a sheet based on a
chosen product code in another sheet in the same excel-file (to be used in
calculating price for different product qualities).

The product code chosen in sheet "Input" should decide which value to be
used from sheet "Furnace"(I prefer a function before VB-programming). There
are ten lines for each product code, i.e. there are many calculations per
product code.

I would be greatful for any help.

Best regards,
Eirik