- This topic has 5 replies, 3 voices, and was last updated 22 years, 1 month ago by
.
-
Posts
-
This is a fairly complicated problem, so i’ll try and make it as simple as I can. Basically, I am making a spreadsheet system which has to calculate the price of a PC when the individual componants are selected. When I select, for example, a processor from the combo box (AKA Drop down list) I want the cell next to the combo box to display a price for that selected processor. In this combo box there are about 5 different brands of processor, so I need the price displayed to change for each individual one. I don’t know if this actually makes any sense to anyone, it hardly makes sense to me! But it’s quite important that I figure out how to do this so any advice would be appreciated. I would leave my email but I don’t think i’m allowed to. Thanks all.
Topic moved from Food, Romance & Other Essential Distractions. Please try to post in a Forum somewhat related to your topic.
yes this is actually fairly simple to do… it involves lookup boxes, where one cell’s contents are drawn from a separate array of cells based on what you select. so basically you’ll have another sheet somewhere (in the same workbook preferably) with tables of values for each component. when you select a component, it looks it up from the table and pulls the correct value out.
if you want, email me your numbers and i’ll throw a quick spreadsheet together for ya
Ah right yeah, i think i get what u mean now, i assume your talking about a VLOOKUP table? I’ll have a go myself then email the stuff to you if I need to. Thanks for ya help!
yep… VLOOKUP or HLOOKUP, i forget exactly which, but either works, just depends on the layout you use
- You must be logged in to reply to this topic.