Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Inventory listing with automatic descriptions and costs

I need to create an excel sheet with mulitple warehouse situations but same
items and costs.
What function should I use to enter the code and have the description pop up
automatically from a list I have...

Thanks,
J
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 459
Default Inventory listing with automatic descriptions and costs

Twin468 wrote:
I need to create an excel sheet with mulitple warehouse situations
but same items and costs.
What function should I use to enter the code and have the description
pop up automatically from a list I have...

Thanks,
J



You need VLOOKUP, remember to use also the fourth parameter to 0.

Check the online help and if you need more help we are here...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Inventory listing with automatic descriptions and costs

Fantastic, thanks!

"Franz Verga" wrote:

Twin468 wrote:
I need to create an excel sheet with mulitple warehouse situations
but same items and costs.
What function should I use to enter the code and have the description
pop up automatically from a list I have...

Thanks,
J



You need VLOOKUP, remember to use also the fourth parameter to 0.

Check the online help and if you need more help we are here...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy



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



All times are GMT +1. The time now is 07:00 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"