Compare 2 work sheet cells and populate based on results

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

Thanks a lot..It worked now

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.