How to make this formula work for more than 1 criteria

[AngleseyExcel]

=IFERROR(INDEX(Table2,SMALL(IF(Table2[Off The Road]="No",ROW(Table2)-4),ROW(43:43)),5),"")

i want it to work if Table2[Off The Road]="No" and Table2[Spare]="No"

I'm not too good with the syntax.

Any help would be greatly appreciated

 

[Sufiyan97]

Try

=IFERROR(INDEX(Table2,SMALL(IF(and(Table2[Off The Road]="No",Table2[Spare]="No"),ROW(Table2)-4),ROW(43:43)),5),"")

 

[Fluff]

As you have 365 why not use the filter function

=FILTER(Table2,(Table2[Off The Road]="No")*(Table2[Spare]="No"))

 

[AngleseyExcel]

Thank you both for replying, very much appreciated

 

[Fluff]

Did you try the formula provided by Sufiyan97, as I doubt it will work.

 

[AngleseyExcel]

As you have 365 why not use the filter function

=FILTER(Table2,(Table2[Off The Road]="No")*(Table2[Spare]="No"))

sorry replied to wrong person

 

[AngleseyExcel]

Did you try the formula provided by Sufiyan97, as I doubt it will work.

yes i tried it, and it gave me a #Spill error

 

[Fluff]

I thought as much, I only asked as you had marked it as the solution.