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. |
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 |