Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with INDEX
Thank you for your help with this.
I have this array formula: =INDEX(BFE!$R$2:$R$1385,MATCH(A3,OFFSET(BFE!$L$2,M ATCH(Sheet2!A3,BFE!$L$2:$L$1385,0)-1,6,-1,-1))) and I get #N/A for the result. What I'm trying achieve is to match a part number (A3 with BFE!L2:L1385) and then get the earliest date (R2:R1385) as the result. The part number is listed many times with varying dates and I need the soonest. Can this be done? TIA Joe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with INDEX
Try this array formula** :
=MIN(IF(BFE!L2:L1385=A3,BFE!R2:R1385)) Format as Date. ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Joe Gieder" wrote in message ... Thank you for your help with this. I have this array formula: =INDEX(BFE!$R$2:$R$1385,MATCH(A3,OFFSET(BFE!$L$2,M ATCH(Sheet2!A3,BFE!$L$2:$L$1385,0)-1,6,-1,-1))) and I get #N/A for the result. What I'm trying achieve is to match a part number (A3 with BFE!L2:L1385) and then get the earliest date (R2:R1385) as the result. The part number is listed many times with varying dates and I need the soonest. Can this be done? TIA Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index vs % | Excel Discussion (Misc queries) | |||
Chart axes color index vs font color index | Charts and Charting in Excel | |||
How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
index/index | Excel Worksheet Functions | |||
Index Row | Excel Worksheet Functions |