Dropdown calculation on different cells

[skatcb]

Okay here is what I am trying to do. If they choose a size in B9, I need K9 to do a calculation. Also if c9 is a certain number than N9 needs to have a calculation completed. Here is one issue it is excel 2003 and I will need more than 7 IF statements if that is the way I have to go. Any help would be appreciated

[111StepsAhead]

samplefile2.zip

In this zip is your project as a .xlsb file. Double click cell A1 that says 'start'. The code is in the background is simply looking at cell B9 and based on the value putting a different value in K9. In your example I only saw 3 formulas so you will have to do the other formulas yourself. You must also double click start for the values to update.

[bstubbs]

It seems like you should be able to establish a table where you could use a vlookup to get the appropriate divisor. So your k9 cell would end up being something like "=e9/vlookup(b9,lookupTableAddress,2,false). Hope that helps.

[tkowal]

Find attached an example of using VLookup to approach your problem.

samplefileVlookup.xls

[skatcb]

Thanks thats the greatest creation I have ever seen, wow!

[skatcb]

I tried to do this myself and cant quite grasp VLOOKUP, can you point me torward a good tutorial

[tkowal]

YouTube Videos of VLOOKUP Tutorials

[skatcb]

Okay I know I am being a pain in the butt now, But I am trying to make the description longer for the size so I can use more conditions. For instance if it might be 36-8FT, or 9 FT, etc. every time I edit it it only shows the first part of the name?

[tkowal]

samplefileVlookup.xls

I don't understand your question?

I noticed that in the Data Validation Lookup List was pulling from Column AM in your spread sheet and there were no long text entries in that column. I changed the lookup to the example table column Column B under your Wallcovering entries and chose the 38 8FT and it appears to display fine ?