Software

Ask something
Discussion Locked

Excel Spreadsheet Functions

0 helpful
1 reply

by kenjensen24

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want my spread sheet to get all the priceing off of one data source. I.E.

Size Tier
A B C
0 $0.00 $0.00 $0.00
12 $14.00 $12.00 $10.00
18 $16.00 $14.00 $12.00

I want to be able to select one of the tiers out of a combo box and have the entire page refer to that particular tier for pricing. Then i want to have another combo box to select the size and in turn put the corresponding cost into another cell. I am not sure if I am explaining what i want well enough. But if you get it and have a solution please, please email me or answer this.

1 reply

by cbergmark

How large is your data list? If it as small as your sample - how about re-arranging the data to
Tier Size price
a 0 0.00
b 0 0.00
a 12 14.00
b 12 12.00
c 12 10.00 (etc.)

Then use AutoFilter to limit tier and size? Not as techy as using combo boxes and forms, but just as effective if your data is small enough.

This discussion is closed to new replies.