Need Help with excel

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
With a formula you can use a simple VLOOKUP. Look in HELP index. Or, you
could use a macro to find the value on ws2 to copy to ws1
 
Hi Jim...........

In cell B1 of Sheet 1, put this formula.............

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top