Data validation

[angie69]

Hi First time here, looking for a solution I`m creating a drop down list but need to move 2 cells instead of 1 can anyone advise how to achieve this.

I have created the drop down menue and it is working but I want it to also move the values in the next cell across as well is this possible.

Dean

[darknation144]

Post a sample workbook please. I think you just want something like in B2 enter =A1. With an escape for blank cells.

[angie69]

Not sure how to post a sample work book happy to email it to you.

[Fotis1991]

Hi angie

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[angie69]

I have tried to attach hope this works

[angie69]

You will see under material a drop down menu when they select one I also want it to bring the value across into the cell next to it. in this example the figure is $ 4800 I have played for hours and can not achieve this. Thanks

[Fotis1991]

excuse me but for me is not clear what is that are you asking for...

In H11, result must be 4800. This means E11*F11

If i choose F/Deck, in G11, what is the corect result??

[angie69]

Hi Fotis,

Thanx for the help I will try and explain.

When they click on F/deck in cell G11 I want the Value $5280 to appair in H11 which needs to come from cell p5
Then if they ckick on say D/sided I want the value to change in H11 to $4800 which relates to the value in P4
I have formulas set up to create the values in P4 and P5 off the simple data they enter.
I`m trying to simplify a complete costing program I have created for my sales team but hit a brick wall with this.

[Fotis1991]

Ok angie. Now you are clear.

So in H11, put this formula. Copy down.
If does not works with semicolon ; change these to gomma(,)

=INDEX($P$3:$P$6;MATCH($G11;$O$3:$O$6;0))

Hope to helps you.

[darknation144]

If you want it to be onClick() you'll need to code some VBA.

[angie69]

Hi Fotis,

Very cool thank you heaps it worked with gomma.

This was a huge help.