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

Here is the simplest way I could think of it:

Please Login or Register  to view this content.

You copy that down in Budget and it will automatically pull it for you.

OR

You name the range of Styles on sheet 2, turn the Styles on sheet 1 into dropdowns via Data Validation, add a column next to it called PER UNIT or something similar, and put:

Please Login or Register  to view this content.

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 :

Please Login or Register  to view this content.

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.

Make sure you aren't editing a cell or copying some cells, press escape, if that doesn't correct it you may need to save and restart excel.