User Tools

Site Tools


training:howtousealookupinexcelforaddingcategories0909301511

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
training:howtousealookupinexcelforaddingcategories0909301511 [2015/04/23 09:54 (9 years ago)] – [Problem Description] sjacksontraining:howtousealookupinexcelforaddingcategories0909301511 [2015/04/23 10:02 (9 years ago)] (current) – [Solution] sjackson
Line 24: Line 24:
  
 ===== Solution ===== ===== Solution =====
-We start with two sheets in excel:+We start with two sheets in Excel:
  
   * The first sheet contains a list of part numbers and quantities, but do not have a category   * The first sheet contains a list of part numbers and quantities, but do not have a category
   * The second sheet contains an export of all parts from system five with category, part number, and an additional field description.    * The second sheet contains an export of all parts from system five with category, part number, and an additional field description. 
  
-We use the formula called "Lookup" in excel to accomplish this. Since the lists may be very long we illustrate how to perform the same actions on a very large list of items. (Excel supports between 64,000 and 65,000 records). +We use the formula called "Lookup" in Excel to accomplish this. Since the lists may be very long we illustrate how to perform the same actions on a very large list of items. (Excel 2003 supports between 64,000 and 65,000 rows, Excel 2007 and higher supports over a million rows). 
  
 There is a multiple step process or work around to make the entry of the formula quick to enter. We talk you though the hows and why's as we do the video. We start by reviewing the initial formula we are looking to write. We don't start off using this formula though. There is a multiple step process or work around to make the entry of the formula quick to enter. We talk you though the hows and why's as we do the video. We start by reviewing the initial formula we are looking to write. We don't start off using this formula though.
Line 43: Line 43:
   * Lookup( replaced by =Lookup(   * Lookup( replaced by =Lookup(
  
-Additionally we do an instert and a copy followed by a paste special to set the changes in stone. Don't forget to save now.+Additionallywe do an insert and a copyfollowed by a paste special to set the changes in stone. Don't forget to save now.
  
 Problems we can run into: Problems we can run into:
training/howtousealookupinexcelforaddingcategories0909301511.txt · Last modified: 2015/04/23 10:02 (9 years ago) by sjackson