Problem with drop-down list
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]
Attachment | Size |
---|---|
z1Help1.xls | 31 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.