Drop Down menu w/ info in other columns
 

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.

Drop Down menu w/ info in other columns
 

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 C7:D7. It will fill the relevant
data into columns B to D, dependent on your choice in A7.

Hope this helps.

Pete

On Jan 11, 4:47*pm, Peebs wrote:
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.