| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function help!
I want to find if one item sold this month is also sold in last month. If
so, return the quantify sold last month. How do I do that? thanks a lot. that is-- to match column 1 and column 3 and then return the value of column 4 column 1 item name sold in this month column 2 item quantity sold this month column 3 item name sold last month column 4 item quantify sold last month |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function help!
Your cols 1 to 4 are assumed to be cols A to D,
with data running in row2 down In E2: =INDEX(D:D,MATCH(A2,C:C,0)) Copy down. Joy? hit the YES below -- Max Singapore --- "CT" wrote: I want to find if one item sold this month is also sold in last month. If so, return the quantify sold last month. How do I do that? thanks a lot. that is-- to match column 1 and column 3 and then return the value of column 4 column 1 item name sold in this month column 2 item quantity sold this month column 3 item name sold last month column 4 item quantify sold last month |
|
#3
|
|||
|
|||
Quote:
copy this formulae from =VLOOKUP(A2,C:D,2,0) E2 to down
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
