Problem with drop-down list

Midsummer007's picture

Hello, everybody!

English is not my native language.
So I use Google Translator.
Sorry for the correctly speech.

That's the problem:

Cell A1 drop-down list (Alpha;Beta;Gamma;Delta;Epsilon;)
I need to:
When I choose in cell A1 'Beta' all values from Table #2 column Beta (orange colored), will automatically change in column '1111' (pink colored) in the same order, that they were in Table #2 column 'Beta' (orange colored).

Similarly, with all others:
When I choose in cell A1 'Alpha' all values from Table #2 column 'Alpha' (Gray colored), will automatically change in column '1111' (pink colored) in the same order, that they were in Table #2 column 'Alpha' (Gray colored).
When I choose in cell A1 'Gamma' all values from Table #2 column 'Gamma' (Yellow colored), will automatically change in column '1111' (pink colored) in the same order, that they were in Table #2 column 'Gamma' (Yellow colored).
When I choose in cell A1 'Delta' all values from Table #2 column 'Delta' (Blue colored), will copy and automatically change '1111' (pink colored) in the same order, that they were in Table #2 column 'Delta' (Blue colored).
When I choose in cell A1 'Epsilon' all values from Table #2 column 'Epsilon' (Green colored), will automatically change in column '1111' (pink colored) in the same order, that they were in Table #2 column 'Epsilon' (Green colored).

I hope you understand me.

I also attached the file. [.xls]

AttachmentSize
z1Help1.xls31 KB

I hope it helps.

Good afternoon.

I´m sorry.

I didn´t find Where or How I can attach a file to the message.

 

Use the HLOOKUP function.

C6 --> =HLOOKUP($A$1,$C$17:$G$26,2,0)

C7 --> =HLOOKUP($A$1,$C$17:$G$26,3,0)

C8 --> =HLOOKUP($A$1,$C$17:$G$26,4,0)

C9 --> =HLOOKUP($A$1,$C$17:$G$26,5,0)

C10 --> =HLOOKUP($A$1,$C$17:$G$26,6,0)

C11 --> =HLOOKUP($A$1,$C$17:$G$26,7,0)

C12 --> =HLOOKUP($A$1,$C$17:$G$26,8,0)

C13 --> =HLOOKUP($A$1,$C$17:$G$26,9,0)

C14 --> =HLOOKUP($A$1,$C$17:$G$26,10,0)

 

I hope it helps.