
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.
Bookmarks