Find Supplier Contact by Material
I need to find the phone number of the supplier who provides 'Drywall', searching through a messy vendor list.
=XLOOKUP("Drywall",A2:A8,C2:C8) How it works: The XLOOKUP function searches for the exact value 'Drywall' within the specified 'lookup_array' (A2:A8, which contains your material list). Once it finds the first match, it returns the corresponding value from the 'return_array' (C2:C8, which contains your phone numbers). This allows you to quickly extract specific contact information without manually scanning through a large dataset.
Data Setup
| Material | Supplier Name | Phone Number | Location | Lead Time (days) |
|---|---|---|---|---|
| Concrete | StrongBuild Inc. | 555-1234 | New York | 5 |
| Steel Beams | MetalWorks Co. | 555-5678 | Chicago | 10 |
| Drywall | WallPro Supply | 555-9012 | Dallas | 3 |
| Lumber | Forestry Ltd. | 555-3456 | Seattle | 7 |
| Insulation | WarmHome Solutions | 555-7890 | Miami | 4 |
| Drywall | Sheetrock King | 555-2468 | Houston | 2 |
| Pipes | AquaFlow Systems | 555-1357 | Boston | 6 |
Step-by-Step Guide
Open your vendor list in Excel.
Identify the column containing the material names (e.g., Column A). This will be your 'lookup_array'.
Identify the column containing the supplier phone numbers (e.g., Column C). This will be your 'return_array'.
In an empty cell, type the XLOOKUP formula: `=XLOOKUP("Drywall",A2:A8,C2:C8)`.
Press Enter to get the phone number for the 'Drywall' supplier.
Explore More
Flag Budget Overruns for Materials
I want a formula that displays 'Over Budget' if the actual material cost exceeds the estimated cost, otherwise 'Within Budget'.
Get Material Cost per Unit
I need to pull the unit cost for 'Concrete' and 'Lumber' from a vendor price list into my estimation sheet.
Count Safety Incidents by Site
I need to count the number of safety reports logged for 'Site A' to monitor compliance.
Calculate Total Hours by Subcontractor
I want to sum the total billable hours worked by the 'Plumbing' subcontractor across all project days.