❌ The Issue The original formula failed because the lookup value ("Product_ID") was being searched in the wrong column of the range, or the column index number was out of bounds for the specified range B2:C100. Additionally, it was missing the exact match argument, defaulting to an approximate match. ✅ Corrected Formula Excel =IFERROR(VLOOKUP(A2, B2:D100, 3, FALSE), "Product Not Found") 🔍 Explanation of Changes Expanded Range: Extended the lookup range to B2:D100 to safely accommodate the 3rd column index. Added Exact Match: Added FALSE (or 0) as the fourth argument to ensure Excel looks for an exact match rather than an approximate one. Error Handling: Wrapped the formula in IFERROR to display a clean "Product Not Found" message instead of an ugly #N/A error when a product ID doesn't exist. 💡 Pro-Tip / Alternative If you are using Excel 365 or 2021, use XLOOKUP instead. It is faster, safer, and doesn't require column counting: Excel =XLOOKUP(A2, B2:B100, D2:D100, "Product Not Found")