Hi Guys,
Working on something and I just can't connect the right function.
Please see below picture for ref.=INDEX(IF(C4="MobilePostpaid",MOBILEPOSTPAID!J:J,BROADBAND!H:H),MATCH(C5,IF(C4="MobilePostpaid",MOBILEPOSTPAID!B:B,BROADBAND!A:A)*(IF(C4="MobilePostpaid",MOBILEPOSTPAID!O:O,BROADBAND!I:I)=C3),0))
Screen Shot 2019-11-07 at 10.19.22 AM.png
Below is the excel file. Appreciate your correction and help on this.
Number appear should be base on the name & product selected according to date.
Bookmarks