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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks