ExcelBanter - Help with INDEX

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help with INDEX (https://www.excelbanter.com/excel-worksheet-functions/204161-help-index.html)

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

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