i want to populate an adjacent cell

[Mark]

I want to be able to enter a part number in say "b2" and then the adjacent cell "c2" would fill in a description automatically and then in "d2" the list price could fill in automatically. Any help is appreciated thanks.

 

[DDM]

Mark, the VLOOKUP worksheet function is just what you need. Look up VLOOKUP
worksheet function in Excel help and also study the first two examples from
David McRitchie's web page:
http://www.mvps.org/dmcritchie/excel/vlookup.htm.

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

I want to be able to enter a part number in say "b2" and then the

adjacent cell "c2" would fill in a description automatically and then in
"d2" the list price could fill in automatically. Any help is appreciated
thanks.