excel formaula

[Guest]

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

 

[Guest]

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

 

[Guest]

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
(e-mail address removed)
remove nospam for email addy!

 

[Guest]

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