Creating interdependent list from a serie of references

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.

Originally Posted by Tony Valko

Sounds like you want to create a table and use a lookup function.

See if this helps:

http://contextures.com/xlFunctions02.html

Many thanks man!!