Have a look at the VLOOKUP function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Eirik Sævareid" wrote in message
...
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