i want to populate an adjacent cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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


Mark said:
I want to be able to enter a part number in say "b2" and then the
Click to expand...
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.
 
Back
Top