Have you tried Data Validation? That should be a good option, as it would
enable you to select the Reg number from a drop down, if you do it
correctly.

Rob

"bobw40" wrote in message
...
I need to compile a log book. What i want to do is input the last 2 text
digits of the registration and have the spreedsheet return the complete
rgistration from a list of complete registrations.