Auto-populating w/ if statements and a drop down box

[thisiscrazy]

I set up a drop down menu and I want the cells below to autopopulate based on the choice made in the data validation.

Choices
Example A
Example B
Example C

Autopopulate
Intermediate additions
Renovations
upgrades

Now that I have written this I don't know if it is clear enough.

I appreciate any guidance.

[NBVC]

No it is not clear enough... you need to elaborate...

Probably you are looking for a simple lookup function?

Maybe an uploaded sample worksheet may help.

[thisiscrazy]

I appreciate the help.

Attached is an outline of what I am hoping to do.

[NBVC]

First name each range...

So select K3 to L4 and enter OptionA in the Name Box just left of the Formula Bar.

Do similar for K6 to L9 and K11 to L16, with names OptionB and OptionC (note: no spaces allowed).

Then in B6 enter formula:

=IFERROR(INDEX(INDIRECT(SUBSTITUTE($B$3," ","")),ROWS($A$1:$A1),COLUMNS($A$1:A$1)),"")

and copy down as far as you want and over to next column, if desired to get prices...

In E3, try:

=VLOOKUP(B3,$G$3:$H$5,2,0)

[thisiscrazy]

That worked perfectly.
Do you recommend those Fred Pryor Excel classes?
Anyway, thanks for all of your help.

[NBVC]

Who is Fred Pryor?

[thisiscrazy]

They are some company that offer a bunch of different seminars on management, HR, excel, etc.

Does the formula change if I need it to be compatible with 2003 or prior?
----
Ok, I just sent it to a friend who has 2003 and he receives a #name error, so I am guessing that I need to alter the formula somehow to be compatible in 2003

[NBVC]

No it is not backward compatible....

Try changing it to:

Please Login or Register  to view this content.

[thisiscrazy]

The new formula works in 2003 but not in 2007.

Does that matter?

Also, I don't get that formula at all, why does it reference two blank cells?

Thanks for all of the help.

[thisiscrazy]

Nevermind... of course it works perfectly.

Thank you so much