| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting a line from a drop-down list
I have a table of data spread over four columns, with the keyword in the first column. What I want to do is select the required keyword from a drop-down list, and have the other related information in the other three cells automatically fill the required fields. For example, the data would be in an array from A3 to D10, and would be hidden so the user cannot see it. The selection fields are in an array from A1 to D1. If I put a drop-down selection list in A1 which is set to choose from A3 to A10, how do I make the rest of the row autofill into the cells B2 to D2? I hope somebody can understand what I want!!! Jonathan -- Jonibenj ------------------------------------------------------------------------ Jonibenj's Profile: http://www.excelforum.com/member.php...o&userid=17048 View this thread: http://www.excelforum.com/showthread...hreadid=492361 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting a line from a drop-down list
Hi, Use a VLOOKUP formula, in B1 copied across. =VLOOKUP($A1,$A$3:$D$10,COLUMN(2:2),0) HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=492361 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting a line from a drop-down list
=VLOOKUP($A1,$A$3:$D$10,COLUMN(),0)
was necessary for me.. "pinmaster" wrote in message ... Hi, Use a VLOOKUP formula, in B1 copied across. =VLOOKUP($A1,$A$3:$D$10,COLUMN(2:2),0) HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=492361 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting a line from a drop-down list
OOPS......should be: =VLOOKUP($A1,$A$3:$D$10,COLUMN(B:B),0) -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=492361 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Selecting a line from a drop-down list
Thanks - it works! Jonathan -- Jonibenj ------------------------------------------------------------------------ Jonibenj's Profile: http://www.excelforum.com/member.php...o&userid=17048 View this thread: http://www.excelforum.com/showthread...hreadid=492361 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
| Drop down list includes hyperlink | Excel Discussion (Misc queries) | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| drop down list | Excel Discussion (Misc queries) | |||
Linear Mode
