can excel do this?
 

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.

You can create atable with vendor names and vendor numbers, then refer to
that table

Assume you type in the vendor name in A1 and you want the number in B1,
the table is on another sheet in range A1:B300

=IF(A1="","",VLOOKUP(A1,Sheet2!,A1:B300,2,0))

for info about vlookup see

http://www.contextures.com/xlFunctions02.html


Regards,

Peo Sjoblom

"Janice@IP" wrote:

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.

Thank you, I went to website you recommended and I will try to sort thru
instructions. If it doesn't work I will be back.

"Peo Sjoblom" wrote:

You can create atable with vendor names and vendor numbers, then refer to
that table

Assume you type in the vendor name in A1 and you want the number in B1,
the table is on another sheet in range A1:B300

=IF(A1="","",VLOOKUP(A1,Sheet2!,A1:B300,2,0))

for info about vlookup see

http://www.contextures.com/xlFunctions02.html


Regards,

Peo Sjoblom

"Janice@IP" wrote:

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.