vlookup works for me -- =VLOOKUP(A1,A18:C20,2,FALSE)
a1 being the input column
a18:c20 is the data range --remember that the left most cell in the data
range must contain the search value

"Nogger-01" wrote:

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 ..