How do you link cells?

[Guest]

I am looking to link cells horizontally so that when a drop down box (list
box) is used and it locates a particular entry that has been selected, it
subsequently populates all the cells for that entry horizontally as well as
the the selected entry from the drop down box. Say the list box is in
A1...it selects an entry from the list below which might be in A45, how can i
set it to populate B45, C45 D45 etc in boxes B1 C1 D1

Any ideas would be appreciated

Justin Kline

 

[Ragdyer]

Try using Vlookup() in *each* of the cells along Row1.

Enter this in B1:
=VLOOKUP($A1,$A$2:$H$100,COLUMNS($A:B),0)

And drag across to copy to Column H.