Function to look up values

  • Thread starter Thread starter Eirik Sævareid
  • Start date Start date
E

Eirik Sævareid

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to look up values 3
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
On an invoice - with sums equations - don't want zero values to sh 2
Automatization routine 3
Automatization of data entry (and return of data) 3
retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file 10
Look Up 2 Values, Match 2 Values Different Tab Return 3rd Value 4
Optional argument as Variant not acting like number 4

Back
Top