A
Alice
This is what I came up with, just to give anyone an idea,
obviously it's wrong I get an value#! error.
=IF(ISNA(VLOOKUP(B4,MSF!$A$2:$D$40000,3,FALSE)
=TRUE),"",VLOOKUP(B4,MSF!$A$2:$D$40000,4,FALSE))*AND(MSF!
E2:E40000>=Breakdown!A1)
obviously it's wrong I get an value#! error.
=IF(ISNA(VLOOKUP(B4,MSF!$A$2:$D$40000,3,FALSE)
=TRUE),"",VLOOKUP(B4,MSF!$A$2:$D$40000,4,FALSE))*AND(MSF!
E2:E40000>=Breakdown!A1)