Newbie alert

[Webby123]

Hi guys...just getting into excel. Loving it so far but keep hitting walls lol..
What im trying to do is this.......

I want to be able to type in the size of material,then select gauge from a dropdown box then select the the quantity from another drop down box then excel to work a price out.

ie

2000x20swgx10
Size x gauge x quantity.

The gauge has 3 different prices and also quantity is cheaper the more you have and goes up in 10s

Hard to understand i know lol

Any help would be great.
Cheers folks

 

[SteveO59L]

Re: Newbiw alert

on the data tab, Data Validation, select the source of your list of variables

 

[Webby123]

Re: Newbiw alert

Right i got that...how do i tell it to pick up tbat price tho

 

[SteveO59L]

Re: Newbiw alert

post a sample of your data, and what you would like to do with it