Debra Dalgleish has lots of notes on =vlookup():
http://www.contextures.com/xlFunctions02.html

atlcasework wrote:

I use Excel 2000 9.0 as a pruchasing program.
I would like for Excel to recognize which vendor
I enter into column c, and then automatically enter
who my sales rep is into column J.
I also would use this same method to recognize
item descriptions in column D and automatically
input the respective part numbers.
Thanks in advance,

--

Dave Peterson