Excel BOM Comparison & Add/Delete List using VLOOKUP & SUMIF Functions - 1 of 2
VLOOKUP and SUMIF functions to prepare a Bill of Materials (BOM) comparison and add/delete list:
**Title: ** "Excel BOM Comparison & Add/Delete List using VLOOKUP & SUMIF Functions"
**Description: **
In this tutorial, we'll show you how to create a Bill of Materials (BOM) comparison and add/delete list in Excel using the powerful VLOOKUP and SUMIF functions. This is a valuable skill for procurement professionals, supply chain managers, and anyone who needs to manage complex materials lists.
We'll start by setting up our data ranges and formulas, and then demonstrate how to use VLOOKUP to retrieve BOM data from one table and SUMIF to calculate the quantities of added or deleted items. We'll then combine these values to create a comprehensive BOM comparison report that highlights the changes between two lists.
By the end of this tutorial, you'll be able to:
Set up your data ranges for BOM comparison
Use VLOOKUP to retrieve BOM data from one table
Use SUMIF to calculate the quantities of added or deleted items
Combine the two values to create a BOM comparison report
Analyze the results to identify changes and trends
This tutorial is designed for intermediate Excel users who are familiar with basic formulas and functions, but may not have experience with advanced techniques like VLOOKUP and SUMIF. By the end of this video, you'll be able to apply these powerful functions to your own projects and improve your Excel skills.
*Time stamps:*
0:30 - Introduction to Bill of Materials (BOM) comparison
3:15 - Setting up data ranges for BOM comparison
6:45 - Using VLOOKUP to retrieve BOM data
10:00 - Using SUMIF to calculate quantities of added or deleted items
13:30 - Combining VLOOKUP and SUMIF formulas for BOM comparison report
17:00 - Analyzing the results and identifying changes
*Keywords:* Excel, Bill of Materials (BOM), BOM comparison, add/delete list, VLOOKUP, SUMIF, procurement, supply chain management