training:howtousealookupinexcelforaddingcategories0909301511
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
training:howtousealookupinexcelforaddingcategories0909301511 [2015/04/23 09:54 (9 years ago)] – [Problem Description] sjackson | training: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 " | + | We use the formula called " |
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 | + | Additionally, we do an insert |
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