Nested IF, AND, OR, VLOOKUP Statement Excel 2016

I need a formula that performs the following: (1) If the value in Raw$G=A5, AND (2) If the value of Raw$J = ng/L OR mg/L OR ug/L, then return the value "mg/L", otherwise return the value in column J. I've copied my two attempts at this, below (one uses a Vlookup, the other just refers to column J directly). Both return the value in J regardless, as though the first half of my equation isn't being interpreted correctly. Any thoughts on what I'm missing, are appreciated!

=IF(OR(Raw!$J:$J="ng/L",Raw!$J:$J="ug/L",Raw!$J:$J="mg/L"),IF(Raw!$G:$G=$A6,"mg/L",Raw!$J:$J))


=IF(OR(Raw!$J:$J="ng/L",Raw!$J:$J="ug/L",Raw!$J:$J="mg/L"),IF(Raw!$G:$G=$A5,"mg/L",VLOOKUP($A5,Raw!$G:$J,4,FALSE)))