Drop Down List with Linked Column

Hi there:

In my Sheet 1, in Column B I have a drop down list to select a name. I have used the data validation to select the name list from Sheet 4 that also has two more column associate with it, i.e., name code and group code. I am looking for way to show all three columns in Sheet 1 when I select the name from drop down menu in Sheet 1. I already have blank column next to name column with drop down.

Sheet 1
Name NameCode GroupCode

Sheet 4
Name NameCode GroupCode

Thank you in advance.

Paul

Use a VLOOKUP formula to lookup the selected name and return the two codes e.g.

C1 (NameCode)
=VLOOKUP(B1,Sheet4!A:C,1,0)

D1 (GroupCode)
=VLOOKUP(B1,Sheet4!A:C,2,0)

Change the lookup columns A:C to suit.