Sorry - I would like help if that's ok? As my Index and Match doesn't work for the data which is linked to the sheet via a data connection to an SQL server but does work for data that's typed into the 2nd spread sheet and I cant work out the reason?