Dont worry, all resolved. It was down to where I was placing the Hyperlink function. A quick check through evaluating the formula and I realised I was placing it in the wrong place.
Thanks anyway.
I have found the link to the original tool that I have adapted which might explain better than I have so far - a picture paints a thousand words as they say.
http://chandoo.org/wp/2011/11/18/formula-forensics-003/
I have used one of the amazing tools from this site to sort only the items from a very long list into a shorter list showing only those that are needed, remember this?
Type Name Criteria Output
Fruit Apple Fruit Apple
Fruit Orange Orange
Veg Broccoli Pear
Veg Spinach <- Cell...