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.