Drop Down menu w/ info in other columns

[Peebs]

I have created a drop down list of Item #s, and want to have relevant info
appear in the columns next to the Item# (column A) in the same row.

ex. - If I choose an something in A7 from a drop down list I created, can I
have info from other cells appear into B7, C7 and D7
(A) (B) (C) (D)
1) ITEM # DESC VENDOR VENDOR #
2)
3)
4)
5)
6)
7) 10004567
..
..
..
33) 10001234 Apples Vendor A 5678-9
34) 10004567 Oranges Vendor B 9876-5


I have a drag down list of items in Column A, put when I choose the item
(10004567) from the drag down list on A7, I need Columns B (Oranges on B34),
C(Vendor B on C34), & D(9876-5 on D34) to populate/auto-fill next to the drag
down list in A7.

I hope this makes sense. Thanks.

 

[Pete_UK]

You would normally use VLOOKUP for this, along the lines of:

=VLOOKUP($A7,$A$33:$D$34,COLUMN(B1),0)

Put this in B7 and copy across into C77. It will fill the relevant
data into columns B to D, dependent on your choice in A7.

Hope this helps.

Pete