Drop-down list & filter

**Jenkkipurkka** · 03-16-2010, 01:36 AM

Hello all,

I've got several columns, like this:

Column A // Column B // Column C

xxxxxxx // 22222222 // abc123ab
zzzzzzzz // 88888888 // cbaab32a
yyyyyyyy // 55555555 // bac32311

What I want to accomplish is a drop-down list that allows me to choose one of the values in column A, and shows the corresponding values of column B and column C.

For instance, if I choose "zzzzzzzz" in the drop-down list, only the following is displayed:

Column A // Column B // Column C

zzzzzzzz // 88888888 // cbaab32a

Thanks in advance!

**teylyn** · 03-16-2010, 01:42 AM

For instance, if I choose "zzzzzzzz" in the drop-down list, only the following is displayed:

is displayed where? In the drop down list or in the cell and the two adjacent cells after you've made your selection in the drop-down list?

If the latter, use column A as your list for data validation and in B and C use a VLookup formula to look up the neighbouring values.