I am trying to pull the info from one workshhet into another. I want to be
able to type in the line number in a specific cell and then in my 2nd
worksheet have all the information from the line item go into the correct
cells on the 2nd sheet

thanks.

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Pam" wrote in message
...
I am trying to pull the info from one workshhet into another. I want to be
able to type in the line number in a specific cell and then in my 2nd
worksheet have all the information from the line item go into the correct
cells on the 2nd sheet

thanks.

In that case, the "pulling" has to be done from sheet2

Assuming line item is in column A of sheet1 and info is in Column B and C

In A1 of sheet2 type the item number.

In B1 enter =VLOOKUP(A1,sheet1!$A$1:$C$100,2,FALSE)

In C1 enter =VLOOKUP(A1,sheet1!$A$1:$C$100,3,FALSE)

If many columns you can enter this in B1 and copy across.

=VLOOKUP(A1,sheet1!$A$1:$C$100,COLUMN(),FALSE)


Gord Dibben MS Excel MVP

On Tue, 20 Nov 2007 13:40:02 -0800, Pam wrote:

I am trying to pull the info from one workshhet into another. I want to be
able to type in the line number in a specific cell and then in my 2nd
worksheet have all the information from the line item go into the correct
cells on the 2nd sheet

thanks.