Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formaula
hi im trying to make a formaula on excel .2003
exmaple= colume A row 1 =fly then it will auto put in colume B row 1 2341 and so on . if you could help me take would be must greatful. paddy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formaula
Hi Paddy
Im assuming that there is no relation between Fly and 2341? What you need to do is on say sheet 2, List your objects in cells A1, A2 etc.. e.g. A1 = Fly, A2 = Dog. A3 = Cat In cells B1,B2, B3 etc, put their values so B1 = 2341, B2 = 1234, B3 = 5578 Once done, in sheet 1, in cell A1, put fly Use a vlookup in B1 that says = vlookup(A1,sheet!2$A1:$B3,2,0) Rob -- Rob Gaffney "paddy 247" wrote: hi im trying to make a formaula on excel .2003 exmaple= colume A row 1 =fly then it will auto put in colume B row 1 2341 and so on . if you could help me take would be must greatful. paddy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formaula
presumably you have a list or table of the values that correspond to fly
etc.That table can be on the same worksheet or a different one,then you can use the tried and true vlookup say your table is on sheet 2 a1:b4 in b1 of sheet 1 type =VLOOKUP(A1,Sheet2!$A$1:$B$4,2) and copy down. This assumes that he table has fly ,bird,spider etc listed in column a and the values corresponding listed in column b paul remove nospam for email addy! "paddy 247" wrote: hi im trying to make a formaula on excel .2003 exmaple= colume A row 1 =fly then it will auto put in colume B row 1 2341 and so on . if you could help me take would be must greatful. paddy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel formaula
hi gaffnr
there is a relation between the part and the nuber's .i wont to be able to just type in the part name and the number will auto fill in the next box thank you paddy "Gaffnr" wrote: Hi Paddy Im assuming that there is no relation between Fly and 2341? What you need to do is on say sheet 2, List your objects in cells A1, A2 etc.. e.g. A1 = Fly, A2 = Dog. A3 = Cat In cells B1,B2, B3 etc, put their values so B1 = 2341, B2 = 1234, B3 = 5578 Once done, in sheet 1, in cell A1, put fly Use a vlookup in B1 that says = vlookup(A1,sheet!2$A1:$B3,2,0) Rob -- Rob Gaffney "paddy 247" wrote: hi im trying to make a formaula on excel .2003 exmaple= colume A row 1 =fly then it will auto put in colume B row 1 2341 and so on . if you could help me take would be must greatful. paddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's wrong with my formaula | Excel Worksheet Functions | |||
Help to write a formaula | Excel Worksheet Functions | |||
including two ranges of cells in an IF formaula | Excel Worksheet Functions | |||
insert rotating formaula | Excel Discussion (Misc queries) | |||
Formaula to multiply and add | Excel Worksheet Functions |