Using REPT & LOOKUP, this is part of the Advanced Excel training series which goes over how to format a Bill of Materials that is being uploaded to an ERP system (an LSMW for SAP in this case). The formatting includes adding indentations to the part number (REPT function) and also indicating the closest parent by searching a column from bottom to top (LOOKUP).
The LOOKUP is a useful trick for searching from bottom to top rather than the typical VLOOKUP which searches from top to bottom.
Excel File:
feito.s3-us-we...
27 авг 2024