Selecting a line from a drop-down list

[Jonibenj]

I have a table of data spread over four columns, with the keyword in th
first column. What I want to do is select the required keyword from
drop-down list, and have the other related information in the othe
three cells automatically fill the required fields.

For example, the data would be in an array from A3 to D10, and would b
hidden so the user cannot see it. The selection fields are in an arra
from A1 to D1. If I put a drop-down selection list in A1 which is se
to choose from A3 to A10, how do I make the rest of the row autofil
into the cells B2 to D2?

I hope somebody can understand what I want!!!

Jonatha

 

[pinmaster]

Hi,
Use a VLOOKUP formula,
in B1 copied across.
=VLOOKUP($A1,$A$3:$D$10,COLUMN(2:2),0)

HTH
JG

 

[JMay]

=VLOOKUP($A1,$A$3:$D$10,COLUMN(),0)
was necessary for me..

 

[pinmaster]

OOPS......should be:

=VLOOKUP($A1,$A$3:$D$10,COLUMN(B:B),0)

 

[Jonibenj]

Thanks - it works!
Jonatha