Pulling info from one worksheet to another

[moniquesantoro]

Hi,
I have a price list on one worksheet with columns for part number description and price.

I need to be able to input the part number in a different worksheet and all the relevant (ie. part number and
price) pull thru to be able to complete quotes.

Please help.

 

[anil.ishaq]

Not sure how your data set looks but you can do a vlookup?
If you give an example of your data then i'll give you a formula