Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating formula to bring back a value.
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 .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating formula to bring back a value.
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 .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bring back .dbf in Excel | Excel Discussion (Misc queries) | |||
i want to create an IF formula to bring back one of four results . | Excel Worksheet Functions | |||
Need to bring back Average using either Sumproduct or CSE formula | Excel Discussion (Misc queries) | |||
Bring back the FORMULA RESULT BAR in excel | New Users to Excel | |||
Bring back the old help format! | Excel Worksheet Functions |