In I2

=IF(OR(A2="Krish",A2="Jacks"),IFERROR(INDEX(Reference!$C$2:$C$100,MATCH($H2,Reference!$A$2:$A$100,0)),"Offshore"),"")

Copy down