Ahh yes that is right, the formula in F14 should be attributed to the F column. I must of accidentally changed the formula when i made the example, in my full spreadsheet the formula works however i just want to make it more concise as there will be over 1000 items populating the full spreadsheet.