Creating formula to bring back a value.

N

Nogger-01

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

dmoney

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup 1
retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file 10
Help to show formula instead of value in a VBA code 1
Creating a UDF to search a cell's formula 13
Vlookup - picking from a formula. 2
Need to bring back 2 vlookup values 2
Insert Row also adds formulas and moves cursor 2
Delete row if formula brings back an error 2

Top