MS Excel drop down box

[Dolby]

I've just read how to create a drop down box - but how do I get the rest of the cells to follow the drop down? For example the drop down is options 318, 320, 323, 325 and 330.

Once I've selected - I'd like the cell next it to display for descriptive, like BMW 318i with ABSA and Leather etc.

If that makes sense :/

 

[Jabberwocky]

create a list

data->data validation
allow: list
source: highlight your list

make sense?

edit:
sorry.. didn`t fully udnerstand the question..

=LOOKUP(A33,L46:L48,M46:M48)

lookup
A33-Value ur looking for
L46;L48 - reference numbers
M45;M48 - Description

 

[Dolby]

Thanks!

I've just realised Excel is more complex than I thought:/

 

[Jabberwocky]

np, let me know if you`re still having a problem, and i`ll make a screenshot.

you should probably also use the $ sign so the formula doesn`t change when you copy it to the cells below
like: =LOOKUP(A33,L$46:L$48,M$46:M$48)