Populate cells based on specified rules

[JimmyG64]

Desired outcome:

Desired outcome: Column J is populated by either residence state or work state, depending on the rule in columns b and c for the specific location. For example, J3 should populate with NY, J6 should populate with OH, and J11 should populate with OK

 

[p45cal]

J6 should populate with OH

Really?!

In J3, the likes of:

=IF(VLOOKUP(G3,$B$3:$C$8,2,0)="Use residence state",H3,I3)

copied down.