Hi,
In N5, I have:
=ArrayFormula(INDEX(A6:A$1730,MATCH(1,
(F5=F6:F$1730)*
("*"&"LC"&"*"=E6:E$1730)*
("*"&"HPT"&"*"=E6:E$1730),
0)))

I'm looking to match the text (an ID) in F5 with the same text later in that column
and 'LC' within E
and "HPT" within E

So if 'LC' and 'HPT' both appear in E and that row matches the ID of F5 I get true.

What I'm trying to do is to have a lookup in N5 to see if there is a future ID with the LC and HPT strings in E of that row and to return the date from A of that row.

I have the following working for a single condition (not an array): IFNA(text(INDEX(A6:A$1730,MATCH(F5,F6:F$1730,0)), " d/m"),"")

If the solution is not an array formula, even better, as I like to avoid volatile formulas..,.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)