Lots of confusion here!

Your formula in I2 is refering to a sheet named ILC data which doesn't exist. If you remove all reference to that sheet, the formula returns "Offshore" on nearly every row.

I can't work out what the rest of the formula is trying to do! Reference sheet only has two rows!

Surely you need a VLOOKUP or MATCH/INDEX formula to get data from this sheet. I can't make sense of the second IF statement.

Regards David

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".