Trouble with Lists

[mikeyfplz]

Hi there,

I am relatively new to Excel but I am working on making a spreadsheet for a company where there are two drop down lists. One lists the type of computer repair: Stage 1, Stage 2, or Stage 3. The next lists the servers size: Small, medium or large. Naturally, a stage 3 detail on a large computer costs a lot more. I would like it so when I changed the type of repair as well as the size of the computer, it will show the values in the hourly, weekly, etc. columns.

Is there a way to do this?

[JBeaucaire]

Show what values? I don't see anything in your sample workbook to demonstrate what exactly you expect to appear.

Expand you sample to include more sample rows and demonstrate what is supposed to appear in C:G...including where that data comes from.

[mikeyfplz]

Sorry, I am at work. My real spreadsheet is at home.

The values are very simple, they're just numbers. For example, Stage 1 and Small would reveal $150/day. Stage 1 and Large would reveal $225. Stage 3 and Large would reveal $475. There is no algorithim to the numbers. They are just prices for the company. I just am trying to figure out that when I change the stage and the size, how to get that price to pop up.

[JBeaucaire]

Continuing with your Faker.xls file...on sheet 4 create a two column lookup table to list all the prices that go with each stage/size combination. I obviously made up most of the column E values.

Please Login or Register  to view this content.

Since you said these were "daily" rates, then back on sheet3 the formula that goes in D2 is:

=VLOOKUP($A2 & " " & $B2, Sheet4!$D:$E, 2, 0)

[JBeaucaire]

Extrapolating on the DAILY rates, here's an example of an entire table...the only rates that are manual are the DAILY rates.