Need formula for price based on quantity and product name on a separate sheet.

Originally Posted by alepoutre

What do you mean by named ranges?

I mean go to sheet 2, select A5:A7, go to formulas tab, define name STYLE

then on sheet 1 on the style cell B5 select, and go to data tab, Data Validation, change to list, and put =STYLE in Source box. Then you create a new column to the right of it and put that code :

=IF(B5<>"",VLOOKUP(B5,Sheet2!$A$5:$B$7,2,0))

That will let you use a dropdown box to select the price per unit IF on sheet 2 the prices are right next to the style in column B, otherwise you need to change that range Sheet2!$A$5:$B$7 to go to the column your price is in and change the number 2 to the column number.

Its a good way to do it that way you can use basic math in your budget field without it getting messy.