Excel 365 Pulling specific text to a main sheet.

[chantel]

I'm looking for a formula to show specific text on an overview tab to track colleague "fails" when preforming audits.

I am working with multiple sheets. for example say i have an overview sheet, then sheets 1,2, and 3.

Sheet2 Cell 'K9' would have the colleagues ID number and cell 'L9' will say "Pass" or "Fail"

Is there a formula for me to bring the text from 'K9' to my Overview Sheet if 'L9' says "Fail"

 

[Radoslaw Poprawski]

yeah, but no data samle its just a bit of guessing game
use vlookup to find ur student, return the Fail/ pass column and compare it with ur "Fail"
engulf it all in if and in True argument of if put "Fail"

you might also consider putting trim and proper function on the retrieved column so the text will be matched perfectly since "fail" <>"fail " or"fail" <> "Fail" etc.