Produce a table from by looking up cells in another table

[hola717]

I have student grades and I would like to see every student that scored below a 70 on each assignment given. Is there a way to produce such a table. I have been experimenting with IF and INDEX and ARRAY, but have not been able to figure it out. Here is a picture of what I am trying to make (though any solution that work would be fine - it does not have to produce the exact same table)
Capture.PNG
Thank you!

I am attaching the file.

[alansidman]

Picture:

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome (manually entered is ok) and how you arrived at that. (Exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you. Also, not all members can upload picture files (Company firewalls, etc.)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[azumi]

Based on you table in ranges A1:E5...

Try this

=IFERROR(INDEX($A$2:$A$5,SMALL(IF(INDEX($B$2:$E$5,0,MATCH(B$8,$B$1:$E$1,0))<=70,ROW($A$2:$A$5)-ROW($A$2)+1),ROWS($A$1:A1))),"-")

Array Formula (Press CTRL-SHIFT-ENTER button together), ENTER alone is not sufficient...

and drag down and cross


or see the file

[hola717]

Thank you!
I will try this.