Combine 2 formulas into one

[kevin440red]

I have a formula that works but need to put a twist on it to look at another column / Sheet.


{=IF(ROWS(E$5:E5)<=$B$8,INDEX(INDIRECT(E$4),SMALL(IF(Date_Received=$A$8,ROW(Date_Received)-ROW(AuditLog!$B$2)+1),ROWS(E$5:E5))),"")} This is working.

I need to add this to it.

=IF(ROWS(F$5:F5)<=$B$11,INDEX(INDIRECT(F$4),SMALL( IF(Time_Returned)=$A$11,ROW(Time_Returned)-ROW(AuditLog!$C$2)+1),ROWS(F$5:F5))),"")

Any help appreciated.

 

[kevin440red]

I have a formula that works but need to put a twist on it to look at another column / Sheet.


{=IF(ROWS(E$5:E5)<=$B$8,INDEX(INDIRECT(E$4),SMALL(IF(Date_Received=$A$8,ROW(Date_Received)-ROW(AuditLog!$B$2)+1),ROWS(E$5:E5))),"")} This is working.

I need to add this to it.

=IF(ROWS(F$5:F5)<=$B$11,INDEX(INDIRECT(F$4),SMALL( IF(Time_Returned)=$A$11,ROW(Time_Returned)-ROW(AuditLog!$C$2)+1),ROWS(F$5:F5))),"")

Any help appreciated.

formula forTime_Return... =IF(ROWS(F$5:F5)<=$B$8,INDEX(INDIRECT(F$4),SMALL(IF(Date_Received=$A$8,ROW(Date_Received)-ROW(AuditLog!$B$2)+1),ROWS(F$5:F5))),"")