Take a look at this approach:
http://www.contextures.com/xlDataVal13.html
"MoronME" wrote:
hi there,
am trying to find a solution on how to automatically generate lists
based from calculated values.
example:
i would like to have the value for D1 and D2 automatically by changing
the value of C1
C1=SupplierA --- my lookup value
A B D
1 Item Supplier jacket
2 jacket supplierA shirt
3 jeans supplierB
4 shirt supplierA
5 briefs supplierC
thank you very much in advance for the help. needed badly.