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

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

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