how to populate field based on previous drop down list selection?

[ItsAllGood]

Hi,

I have numerous lists which contain code and price of items.

I would like to create drop down selections which will populate the following field based on the selection made.

In my attached example i have three columns that need to be populated.
I have managed to figure out how to display the correct options in the 'List' & 'Code' columns but can't figure out how to get the correct 'price' to display based on the selected item from the 'code' drop down list.

I hope this makes sense and someone can help me?

Thanks!

[BigBas]

This is one of doing it.

First, make two more named ranges, List1a and List2a. List1a will refer to cells C8:D12 (the list 1 range). List2a will refer to cells F8:G12 (the list 2 range).

Now, in cell D4, enter this formula:

Please Login or Register  to view this content.

Report back if you have any further questions.

[ItsAllGood]

Thankyou so much BigBas....!

It works perfectly on the example.

I'll apply it to my working spreadsheet and see how i go.

Thanks again..!