jeudi 5 novembre 2015

Indexing items if two conditions match Excel

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