I have excel set up to keep up with bills I pay at work. I input the vendor
name and then put in vendor number, invoice, etc.

Is there a way to set it up to automaticly put in vendor number when I type
in vendor name? What criteria would I use for that? I do not know much
about excel. I can use simple formulas & such but not pivot tables, macros,
etc. Hope someone can give me simple instructions for this if it is possible
or tell me what to look for in help.