Drop-Down List Value populates adjacent cells

[Tony]

I have a worksheet that has data records based on a form number. I am
creating a form on a separate worksheet 2 (same workbook) that will populate
the cells based on selecting a drop-down value. If you click on the list in
Cell 1 on worksheet 2, it should automatically fill in cells C2 (Duncan) and
C3(Female) and C4 (46).

Worksheet 1

C1 C2 C3 C4
R1 Tom Duncan Male 51
R2 Cheryl Duncan Female 46
R3 David Duncan Male 15

Worksheet 2

C1 C2 C3 C4
R1 Cheryl Duncan Female 46
R2
R3

I am under the impression that I would use the Activecell statement with
Offset and this should fill in the values but I end up with zero (0) values.

Can someone help out?

 

[Martin Fishlock]

I would try using vlookup on the form selecting the key a the value in the
data validation drop down.