Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Item List in Excel


Is it possible to have an item menu in excel like the one in quickbooks
or quicken? a Menu where you can choose an item and excel automatically
fills in the blanks in the line "i.e. pick an item from the menu and
excel puts in how much it cost,how many pkgs in the case,retail
price,etc. etc. etc."
did I explain that correctly? I hope I did.
Thanks for the help in advance


--
julywizard
------------------------------------------------------------------------
julywizard's Profile: http://www.excelforum.com/member.php...o&userid=31302
View this thread: http://www.excelforum.com/showthread...hreadid=509862

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default Item List in Excel

Hi JulyWizard,

See Debra Dalgleish's VLppkup tutorial at:

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


---
Regards,
Norman


"julywizard" wrote
in message ...

Is it possible to have an item menu in excel like the one in quickbooks
or quicken? a Menu where you can choose an item and excel automatically
fills in the blanks in the line "i.e. pick an item from the menu and
excel puts in how much it cost,how many pkgs in the case,retail
price,etc. etc. etc."
did I explain that correctly? I hope I did.
Thanks for the help in advance


--
julywizard
------------------------------------------------------------------------
julywizard's Profile:
http://www.excelforum.com/member.php...o&userid=31302
View this thread: http://www.excelforum.com/showthread...hreadid=509862



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default Item List in Excel

See Debra Dalgleish's VLppkup tutorial at:

See Debra Dalgleish's VLookup tutorial at

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi JulyWizard,

See Debra Dalgleish's VLppkup tutorial at:

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


---
Regards,
Norman



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I choose more than one item from list in a form in Excel? Jolly Excel Worksheet Functions 7 July 14th 08 06:28 PM
Excel Lists - get an item in a list to automatically bring in info fireman112473 Excel Discussion (Misc queries) 2 May 28th 08 09:36 PM
I need to pair each item on one list to each item on another list Peter R. Excel Worksheet Functions 1 August 24th 07 03:04 AM
Setting up a list where an item can only be picked once in Excel J. Excel Worksheet Functions 2 May 17th 07 01:17 AM
Selecting an Item from a List and getting a different item to pop. Matt Excel Worksheet Functions 1 December 7th 04 02:37 PM


All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"