Line Item

[Guest]

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.

 

[T. Valko]

See if this helps:

http://contextures.com/xlFunctions02.html

 

[Gord Dibben]

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