LinkBack URL
About LinkBacks
Hi
Use in B2
Formula:
=IFERROR(IF(LEFT(A20,1)="F",AGGREGATE(15,6,1/(1/(('Tube Prices'!$D$2:$D$6)*('Tube Prices'!$A$2:$A$6=A20)*('Tube Prices'!$B$2:$B$6<=C20)*('Tube Prices'!$C$2:$C$6>=D20))),1),),)
Hi
Use in B2
Formula:=IFERROR(IF(LEFT(A20,1)="F",AGGREGATE(15,6,1/(1/(('Tube Prices'!$D$2:$D$6)*('Tube Prices'!$A$2:$A$6=A20)*('Tube Prices'!$B$2:$B$6<=C20)*('Tube Prices'!$C$2:$C$6>=D20))),1),),)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks