Cascading values depending on dropdown selection

Hi all, I am a complete novice noob to excel, I don't even know if I am in the correct part of the forum for this post to be honest, but here goes',
can anyone help me on a formula that works like this

I have cell with drop down menu ( which I have done ) when you select an item in the menu, it puts a number in another cell,
then when that is a certain number, then another number appears in another cell e.g.

(cell E46 )"Ring gasket size R24" ( this is the item in the drop down list )(Cell H46) "Ref:10" ( this is the next cell's number ) (Cell J46) "$17.50" ( this is the number to be shown in the final cell )so would look like this :

Ring Gasket size R24 Ref: 10 $17.50

but I want the reference number and the price number to change with the change of item e.g.

Ring Gasket size R36 Ref: 23 $28.50 and so on

I was given this formula but it doesn't work.

=IF(E46='10',J46=$17.50),OR=IF(E46='23',J46=$28.50)

any ideas would be helpful this is sort of an emergency as been working on this for ages, please also bear in mind, I am a novice and do not know what I am doing 100% yet otherwise I wouldn't be here asking for you guys/gals to help, so please tread gently thanks

You should add a sheet to your workbook where you list the drop down values in Column A, column B is the matching REF numbers, and column C is the matching prices.

Then on your sheet with the drop down, let's say that was cell E46, then you could use VLOOKUP formulas to handle getting the second two values to appear. Assuming the reference sheet was Sheet2, then

H46: =VLOOKUP(E46, Sheet2!A:C, 2, 0)
J46: =VLOOKUP(E46, Sheet2!A:C, 3, 0)

Edit as needed.