In B1 of the first sheet
=vlookup(A1,Sheet2!A:B,2,false)

or
=if(A1="","",vlookup(A1,Sheet2!A:B,2,false))

--
Regards,
Tom Ogilvy


"Jim" wrote in message
...
Hi all I have something id like to do with excel but havent been able
to get it to work. Here is basically what Im trying to do.

I have 2 worksheets in an excel file. I want to be able to put a
number in in worksheet 1 cell a1 and when I put that number in have it
go to worksheet 2 search cell a1 there till if finds the number then
have it take the number across from it in column B and copy that
number back to worksheet 1 and put it in cell b1.

Can anyone help me with this.

Thanks

Jim