Excel

[Harv]

Right well basically I have to produce a database model using Excel (cant use any other programs to do this) to create a Car Insurance Premium Quote for my A level coursework.

On the page where the user has to select the car manufacturer and model etc. Is there a way of creating many nested IF's inside each other and using VLOOKUPS etc? I thought the maximum was 7 but I some how need to create a drop down list to choose. One for the manufacture then one for the car model. The car model has to then change according to which manufacture you select ie. a dynamic VLOOKUP.

Is there a way of doing this?

Rep will be given as always
Ta

[vidal]

Not used this article...
http://pubs.logicalexpressions.com/P...cle.asp?ID=446

but it looks as if it's what you want.

V.

[Ross-1987]

do you mean, each cell having an if statement while using a VLOOK up table?

[Harv]

Originally Posted by vidal

Not used this article...
http://pubs.logicalexpressions.com/P...cle.asp?ID=446

but it looks as if it's what you want.

V.

cheers V. I will have a look at it tomorrow as I'm on the iPod at the moment. will rep you aswell tomorrow

Originally Posted by Ross-1987

do you mean, each cell having an if statement while using a VLOOK up table?

hmmmmm........basically all I want is a selection of car manufacturers in one combo box and then car models in another one. but the car models need to change when a different manufacturer is selected. Basically I'm after the same thing as the auto-trader selection and parkers guide etc. Is it possible?

I will look at it again tomorrow night. rep will be given tomorrow

[vidal]

Not sure if this can be adapted, maybe via a bit of scripting, macros etc..

http://www.dynamicdrive.com/dynamici...ects/index.htm

V.

[Ross-1987]

Originally Posted by harvmate

cheers V. I will have a look at it tomorrow as I'm on the iPod at the moment. will rep you aswell tomorrow



hmmmmm........basically all I want is a selection of car manufacturers in one combo box and then car models in another one. but the car models need to change when a different manufacturer is selected. Basically I'm after the same thing as the auto-trader selection and parkers guide etc. Is it possible?

I will look at it again tomorrow night. rep will be given tomorrow

I did this for A-level last year, im going to have a dable in mo, just i have a crap memory and cant member shiz

[Ross-1987]

i dont think you can do this, although its on a website this is set up via java scripting, so im not overly sure if it can be done on Excel, if you can it wont be an easy task, is there no other way you can do this to meet the criteria, or are you just trying to be a flash bastard

[E1999G]

Dont no if its possible but think u need it to say ( IF vw selected then vlookup golf polo lupo) i think thats what you need to do but not sure how

[Harv]

Originally Posted by vidal

Not sure if this can be adapted, maybe via a bit of scripting, macros etc..

http://www.dynamicdrive.com/dynamici...ects/index.htm

V.

Just having a look at that now. I need to spread the love before I can rep you again . Hmmm seems to be quite difficult.

Originally Posted by Ross-1987

i dont think you can do this, although its on a website this is set up via java scripting, so im not overly sure if it can be done on Excel, if you can it wont be an easy task, is there no other way you can do this to meet the criteria, or are you just trying to be a flash bastard

Erm.....well, there is probably another way of getting around it. And yea....I am trying to be flash - aiming to make it as proffesional as possible. I'll have to check with my teacher if I can do it or not . I could just enter a few 'fictional' number plates into a database and give a demo on how it would find your number plate in real life. Thats just a simple thing to do . Hmm i'll see what I can do