If you have part Nos and descriptions in Sheet2, columns A:B, and enter part
No in Sheet1 A2 then
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)
returns the description.

Regards,
Stefi

€žTMansell€� ezt Ã*rta:

I am trying to create a formula for an invoice. When a specific part number
is entered into the cell that in the next cell the description is pulled up.
All the information is on a seperate worksheet?? Ahhhh! Help Please this is
driving me nuts!!
--
TMansell