Formula needs tweeked

[Noxqss38242]

=IF(N327356="A",0,IFNA(AB327356-LOOKUP(2,1/(N$2:N327356="A")/(B$2:B327356=B327356),AB$2:AB327356),""))

In this formula I'm asking it to search for "A" and how long it has been since "A" was done based off the same identifier in column B.

What I'm wondering is, can this code be modified to look for "A", "B", "C", "E", and "I" at the same time? So instead of possibly 200 days lapsed just for "A" it will show 45 days lapsed based off this new information it is also looking for.

Column B = Numeral Number Assigned to a Truck
Column N = Work Code. ie: A, B, C, D, E, I
Column AB = Date Work Done

 

[Noxqss38242]

Maybe:

=IF(N163643="B",0,IFNA(LOOKUP(2,1/ISNUMBER(SEARCH(N$2:N163643,"ABCEI"))/(B$2:B163643=B163643),AF$2:AF163643),""))

Genius, pure genius. It treats "blanks" as a good code though, so luckily I only had to fill in 116 blanks of over 250,000 rows. No big deal, it works! Much appreciated!