Massive thanks for the reply although I now realise I've asked the wrong type of question.
I unfortunately have to perform the following on Old data - and there is no way of getting around it.
Look for "Reference" in another table so i can use the Instr function to update a column with "Yes"...