Hii all,

im facing several problems in making my report. Thing is, i have several reference groups that connected each other, as example : "products" "suplier" "brand", below is the lists:


"Products" "suplier" "brand"

A ono X1
B Gelo X2
C Super X3

I am familiar for making a list from Data Validation function, what i want to have is if i made a list containing a Product name in one cell, the other two cells next after it will change automatically into the product's suplier and brand. For example: if i create cell A1 from a drop down list and choose product "B", i want the cell B1 automatically filled up by "Gelo" and cell C1 by "X1". Any help will be appriciated, sorry for my bad english.

Cheers.