Search:

Thanks Pete, I resolved the situation, using the case statements, which isn't a perfect way of programming. But if I create a similar program I will keep that context in mind, many thanks.

I have the same problem with the vlookup not recognising the format on a string (Months January to December) although I have tried both Text and General.
The Vlookup defaults if I use a cell...