Let us say you have the below information in Sheet2 Range("A1:C3")

Column A to C
Row1 Dog,brown,4 to 8
Row2 Bird,black,1 to 3
Row3 Mouse,gray, 9 to 15

In Sheet1.
Set Datavalidation for Col A as list and set Range as Sheet2:A:A
Set Datavalidation for Col B as list and set Range as Sheet2:B:B
Set Datavalidation for Col C as list and set Range as Sheet2:C:B

Set formula in Sheet1 B1
=IF(ISNA(MATCH(A1,Sheet2!A$1:A$3,0))=TRUE,"",INDEX (Sheet2!A$1:C$3,MATCH(A1,Sheet2!A$1:A$3,0),2))

Set formula in Sheet1 C1
=IF(ISNA(MATCH(A1,Sheet2!A$1:A$3,0))=TRUE,"",INDEX (Sheet2!A$1:C$3,MATCH(A1,Sheet2!A$1:A$3,0),3))


If this post helps click Yes
--------------
Jacob Skaria