Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i lookup the value of the next cell excluding the first lookedupresult
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i lookup the value of the next cell excluding the first loo
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i lookup the value of the next cell excluding the firstloo
ok, thanks toppers. will try.
Toppers wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i lookup the value of the next cell excluding the firstloo
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. Toppers wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I lookup a cell that's to the left? | Excel Discussion (Misc queries) | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Return cell reference of lookup value | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |