how do i lookup the value of the next cell excluding the first lookedup result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MoronME - 19 Apr 2006 15:15 GMT

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.

Reply to this Message

Toppers - 19 Apr 2006 16:40 GMT

Take a look at this approach:

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

> hi there,
>
[quoted text clipped - 15 lines]
>
> thank you very much in advance for the help. needed badly.

Reply to this Message

MoronME - 19 Apr 2006 16:56 GMT

ok, thanks toppers. will try.

> Take a look at this approach:
>
[quoted text clipped - 19 lines]
>>
>> thank you very much in advance for the help. needed badly.

Reply to this Message

MoronME - 20 Apr 2006 16:13 GMT

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.

> Take a look at this approach:
>
[quoted text clipped - 19 lines]
>>
>> thank you very much in advance for the help. needed badly.

Reply to this Message