Drop Down menus fill in automatically

**karenH** · 09-12-2009, 03:41 PM

I am creating a custom invoice. I have created a drop down menu for product catalog numbers. What I want to do is this:

When I select from the drop down the catalog number (column A) and have the product name (column B) and Unit price (column C) appear automatically (based on the catalog number).

Anyone?????? This is kind of urgent so if you could send an answer to my email I would really appreciate it. omia1234@gmail.com

Thanks,

Karen
www.soulful-relationships.com

**shg** · 09-12-2009, 03:46 PM

See Help for the VLOOKUP function.

so if you could send an answer to my email ...

That would kinda defeat the purpose of a forum, huh?

**trucker10** · 09-12-2009, 07:00 PM

Originally Posted by karenH

When I select from the drop down the catalog number (column A) and have the product name (column B) and Unit price (column C) appear automatically (based on the catalog number).

Thanks,

Karen
www.soulful-relationships.com

something like this ( with a special validation )

**JBeaucaire** · 09-12-2009, 07:37 PM

Originally Posted by karenH

Anyone?????? This is kind of urgent so if you could send an answer to my email I would really appreciate it. XXXXXXX@gmail.com

I think posting an email address in an open forum is probably asking to get spammed, not the greatest idea.

Also, if you fill out your OPTIONS page on the forum, too, fully, you can set it to notify you by email anytime your threads are answered...exactly what it appears you want.

http://www.excelforum.com/profile.php?do=editoptions

**arshab1** · 09-12-2009, 07:58 PM

I want a formula for a game which is "a"=1 "b"=2 "c"=3......... i want to ask a word to the contestent by just giving him the total of abc, can any one help me?

**JBeaucaire** · 09-12-2009, 08:12 PM

Originally Posted by arshab1

I want a formula for a game which is "a"=1 "b"=2 "c"=3......... i want to ask a word to the contestent by just giving him the total of abc, can any one help me?

Not in someone else's thread, no.

First, read the The Forum Rules so you can follow them effectively. Then post your own thread with enough information that we can fully understand your need.