lundi 4 février 2019

IF OR Formula not matching with one of the criteria

I am trying to pull through the Top 20 data from two spreadsheets based on what the user chooses on the dropdown list.

All information pull through correctly except for the "POSTAL" data which comes out as #value. I have double checked all data to make sure there wasn't any differences such as spaces or commas etc but all is ok it just seems to not match up with the Postal selection. Could you please advice on the below error.

=LARGE(IF(OR($C$22="CRT",$C$22="CSN",$C$22="SCR"),IF('Certificated Data'!$A$2:$A$1048575=Sheet1!$C$22,IF('Certificated Data'!$J$2:$J$1048575=Sheet1!$C$24,IF('Certificated Data'!$I$2:$I$1048575=$C$23,'Certificated Data'!$F$2:$F$1048575))),IF(OR($C$22="POSTAL",$C$22="SAYE"),IF(INFODATA!$AF$6:$AF$1048576=Sheet1!$C$22,IF(INFODATA!$AH$6:$AH$27239=Sheet1!$C$24,IF(INFODATA!$AG$6:$AG$27239=$C$23,INFODATA!$AC$6:$AC$1048576))))),ROW(A1))

Aucun commentaire:

Enregistrer un commentaire