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

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

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

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

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