Pass/fail result from data table

I have attached the document i am working on. I will be entering a Ref and 2 results (A & B). I would then like it to be able to automatically reference the data on sheet 2 to see if it passes or fails. How this is best done I'm not sure. I had thought of a check box but this may not be the best method. Green or red colour would be great. May not need the pass and fail column?
Any help would be fantastic as i have been sat staring for a long time with no real solution.
Many thanks