Please pay special attention to what you are posting here. If you keep "misrepresenting" things, the formulas will never work. All that we have to work off if what you share with us here. So we need to count on that data being accurate.
Basically, what we are building is an IF statement with an AND clause. Its structure looks like this:
=IF(AND(condition1,condition2,condition3),'QC W Beam'!G29,"")
If condition1, condition2, and condition3 all return TRUE, then the formula HAS to return the value from 'QC W Beam'!G29.
So, if it is not working the way you expect, then pull out each condition (like I just had you do above), and see if each condition is True or not.
I would also recommend temporarily changing the last argument of the IF function to something other than "", maybe with something like "conditions not met".
That way, you will be able to tell the difference between the IF conditions not being met versus them being met, but the cell you are bringing back is empty.