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