Hi,

I am creating a speadsheet that once i type in a service number in it will
automatically bring back the registration data into another field along with
the depot codes. i have tried a vlookup formula but it doesnt seem to work.

could some one please help me on the matter.

below is the information i am planning to use.

A1 = Service number e.g. 26(27)
B1 = Depot Code e.g. GL
C1 = Registration numbers e.g. PC 0002598/7

I need the sheet for example when i type in service 26 it will paste into
another cell the registration number and then in the cell next to it the
depot code.

would be greatfull if someone could haelp me on this matter cheers ..