Link to Picture -----> Link to my Excel File ----->
If you download the excel file, you can see that in the first sheet I have a list of example students and a bunch of parameters. The two important parameters are the "Y" or "N" in column H and the "TRUE" or "FALSE" in column P. Column P displays TRUE because the "Sent to Flight Data" checkbox is checked.
Now the issue I have is. In the Step 2 sheet, I want the In-House table to be filled with the information from Step 1, BUT the DE table has to be filled in if the DE box has a "Y" and if the P column from sheet 1 is "True".
I used in the DE table "=IF(AND('Step 1 - Paperwork'!$P3=TRUE, 'Step 1 - Paperwork'!$H3="Y", )'Step 1 - Paperwork'!A3, "")"
But... as you can see. El Darazi is the only student to match both conditions. But he appears down the list and not as the first result. I want the table to be filled correctly...
Hope that made sense....
Aucun commentaire:
Enregistrer un commentaire