Error message on already completed cells in excel

H2O 

Thank you very much for the reply! I just realise that I didn't express myself quite clearly in the original post. In this case the category is not static. Example, today the category can be named "fruit" tomorrow it can be anything else. 

I'm creating a template where a user can decide what the category is. So, I need to insert a formula where it points to a specific cell, irrespective of its name.

To create the original dropdown list I created a dependent dropdown by using the "offset" & "match" capability to cater for the dynamic properties of the capabilities. 

So, instead of saying "fruit" in the formula, how do I point excel to a dynamic range? I have 6 possible categories, with 6 possible related entries which can be anything as per the user's original entries.