how do i lookup the value of the next cell excluding the first lookedupresult

[MoronME]

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.

 

[Guest]

Take a look at this approach:

http://www.contextures.com/xlDataVal13.html

 

[MoronME]

ok, thanks toppers. will try.

Take a look at this approach:

http://www.contextures.com/xlDataVal13.html

 

[MoronME]

hi, i had made the formula and is working the way it must be to generate
the values in D1 and D2 while changing the value of C1 or the supplier,
which in this example is supplierA.
is there a way (formula or anything) that excel can do to automatically
generate D1 and D2 while i change C1. e.g. if C1 is SupplierA and i had
chosen supplierA, D1 and D2's value will automatically be generated. as
of now when i click C1, the value for D1 and D2's value is on a dropdown
list in which i had to choose from that the value of D1 and D2.
any workarounds or improvement ideas from the group that might help will
be very much appreciated.

thanks.