Changed cell value based on value in another cell (drop down menu)

Hi,

I have a excel document that I am having trouble with. I have my drop down menu which are coming from a source on a seperate sheet - no problem.

When I change the value in the drop down (Sheet 1, B14) I would like the cell next to it (C14) to also change value, and then finally another two cells away (E14) to also change.

The idea is I select a product code, which then changes the description and price of an item. I have used the below IF formula, which is working for ONE drop down:

=IF(B14="ProductCode","ProductDescriptionOne")

However I have about 30 drop down options in the list, and I am not sure how to set the rest of them to complete the same function.

Please could somebody advise and let me know if they need any more info.

Any help is appreciated.
Danny.

Hello,

Please find attached.

As you can see I have 'Code1' sorted with changing the description and price using IF rules, however I would like to achieve this with all of the codes.

I don't mind manually inserting the description and price into each formula if I have too.

Thanks,
Danny.Sample Workbook.xlsxSample Workbook.xlsx

Hi,

I think you need to put the following formula to your spread sheet and see if this is what you are looking for?

Cell C14 = VLOOKUP($B$14,'Codes - Descriptions - Prices'!A1:C31,2,FALSE)

Cell E14 = VLOOKUP($B$14,'Codes - Descriptions - Prices'!A2:C31,3,FALSE)

See the attachment.

I hope this is what you are looking for. Let me know, if it works for you.

Thanks.

Perfect, thank you so much!

That is exactly what I was looking for I will work on inserting all the products now!

Thanks!

Originally Posted by DannyB94

Perfect, thank you so much!

That is exactly what I was looking for I will work on inserting all the products now!

Thanks!

Great. Don't forget to set the post status as Resolved and also hit the * (Star) to add reputation.

Thanks.

Hi,

CAn anyone help me to change drop down source depend on the value in another drop down.?

Hi,
I have same issue but in different way. I want to change one drop down value depending on the selected value of some another drop down value.

Any help is appreciated.

Regards,
Mrudula.

Originally Posted by sktneer

Hi,

I think you need to put the following formula to your spread sheet and see if this is what you are looking for?

Cell C14 = VLOOKUP($B$14,'Codes - Descriptions - Prices'!A1:C31,2,FALSE)

Cell E14 = VLOOKUP($B$14,'Codes - Descriptions - Prices'!A2:C31,3,FALSE)

See the attachment.

I hope this is what you are looking for. Let me know, if it works for you.

Thanks.