Please try
=FILTER(Table1,IFERROR(XLOOKUP(A12,Table1[#Headers],Table1,YEAR(Table1[Target Return to Service Date - No Delays]))=B12,0))
Please try
=FILTER(Table1,IFERROR(XLOOKUP(A12,Table1[#Headers],Table1,YEAR(Table1[Target Return to Service Date - No Delays]))=B12,0))
Bo-Ry,
That seems to work, I have changed it to the heading I wanted (Next Out-of-Service Inspection Due Date). I will now try and add it to the end of my working formula.
Thank you
It worked!!
Thank you so very much.
What community!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks